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)