sdasd
Tables (8)
customer (Untitled2)
- customer_id (Key) — int — Primary key — NOT NULL
- name (Field) — vchar(20)
- gender (Field2) — boolean
- birth (Field3) — datetime
- phone (Field4) — vchar(14)
- savings (Field5) — int
employee (Untitled)
- employee_id (Key) — int — Primary key — NOT NULL
- login_id (Field) — vchar(20)
- login_pw (Field2) — vchar(20)
- name (Field3) — vchar(20)
- gender (Field4) — bit
- social_number (Field5) — vchar(15)
- phone (Field6) — vchar(14)
- adress (Field7) — vchar(30)
- start_date (Field8) — datetime
- end_date (Field9) — datetime
- rank (Field10) — vchar(10)
product (Untitled3)
- product_id (Key) — int — Primary key — NOT NULL
- number (Field) — int
- name (Field2) — vchar(20)
- manufacture (Field3) — datetime
- cpu (Field4) — vchar(20)
- inch (Field5) — vchar(10)
- mAh (Field6) — int
- ram (Field7) — int
- brand (Field8) — varchar(10)
- camera (Field9) — varchar(50)
- weight (Field10) — int
- price (Field11) — bigint
- display (Field12) — vchar(20)
- memory (Field13) — int
sales_history (Untitled8)
- sales_history_id (Key) — int — Primary key — NOT NULL
- customer_id (Key2) — int — Foreign key → customer.customer_id — NOT NULL
- employee_id (Key3) — int — Foreign key → employee.employee_id — NOT NULL
- sales_date (Field) — datetime
- type (Field2) — vchar(10)
sales_product (Untitled7)
- sales_id (Key) — int — Primary key — NOT NULL
- sales_history_id (Key2) — int — Foreign key → sales_history.sales_history_id — NOT NULL
- product_id (Key3) — int — Foreign key → product.product_id — NOT NULL
- memory (Field) — int
- quantity (Field2) — int
- color (Field3) — vchar(20)
stock_product (Untitled4)
- stock_id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
- color (Field2) — vchar(20)
- stock (Field3) — int
trade_history (Untitled6)
- trade_history_id (Key) — int — Primary key — NOT NULL
- employee_id (Key2) — int — Foreign key → employee.employee_id — NOT NULL
- trade_date (Field) — datetime
trade_product (Untitled5)
- trade_id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
- trade_history_id (Key3) — int — Foreign key → trade_history.trade_history_id — NOT NULL
- memory (Field) — int
- color (Field2) — vchar(20)
- quantity (Field3) — int
- trade_type (Field4) — vchar(10)