Mobile Store Database

create database Mobileـstore
create table customers
(
cus_id int constraint PK__customer_cus_id primary key,
cus_fullname nvarchar(60),
cus_phone char(11),
cus_address nvarchar(max),
cus_brithday date
)
create table orders
(
cus_id int constraint FK__customer_cus_id foreign key references customers(cus_id),
mobile_model nvarchar(50),
mobile_brand nvarchar(30),
mobile_price money
)

Sajad.karimi

S

Download DataBase

import sqlite3

db = sqlite3.connect("shop_db.sqlite")
cur = db.cursor()

cur.execute('''
            CREATE TABLE IF NOT EXISTS customers(
            id INTEGER PRIMARY KEY,
            f_name VARCHAR(50),
            phone VARCHAR(11),
            address STRING,
            birth_year INTEGER
            )
        ''')

db.commit()

cur.execute('''
            CREATE TABLE IF NOT EXISTS orders(
            id INTEGER PRIMARY KEY,
            model STRING,
            brand STRING,
            price INTEGER,
            user_id INTEGER
            )
        ''')

db.commit()
db.close()

User 362

3

Download DataBase

-- ایجاد جدول مشتریان
CREATE TABLE customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    full_name VARCHAR(100) NOT NULL,
    mobile_number VARCHAR(15) NOT NULL UNIQUE,
    address VARCHAR(255) NOT NULL,
    birth_year INT NOT NULL
);

-- ایجاد جدول سفارشات
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT NOT NULL,
    mobile_model VARCHAR(100) NOT NULL,
    mobile_brand VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);

Mma123

M

Download DataBase