pos

Tables (12)

admin

  • admin_id — INT — Primary key — NOT NULL
  • username — VARCHAR(30)
  • userid — VARCHAR(20)
  • userpw — VARCHAR(20)
  • phone1 — INT
  • phone2 — INT
  • phone3 — INT

cart

  • cart_id — INT — Primary key — NOT NULL
  • customer_id — INT
  • product_id — INT

category

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(50)
  • scale_type — VARCHAR(50)

customer

  • customer_id — INT — NOT NULL
  • username — VARCHAR(30)
  • userid — VARCHAR(20)
  • userpw — VARCHAR(20)
  • addr1 — VARCHAR(100)
  • addr2 — VARCHAR(100)
  • email1 — VARCHAR(100)
  • email2 — VARCHAR(100)
  • phone1 — INT
  • phone2 — INT
  • phone3 — INT
  • points — INT
  • birthdate — DATETIME

delivery_addr

  • delivery_addr_id — INT — Primary key — NOT NULL
  • customer_id — INT
  • addr_type — VARCHAR(30)
  • addr1 — VARCHAR(100)
  • addr2 — VARCHAR(100)
  • post — INT
  • phone1 — INT
  • phone2 — INT
  • phone3 — INT
  • is_default — BOOL

delivery_state

  • delivery_id — INT — Primary key — NOT NULL
  • delivery_state — VARCHAR(50)

discount

  • discount_id — INT — Primary key — NOT NULL
  • discount_type — VARCHAR(50)
  • discount_rate — DOUBLE
  • start_date — DATETIME
  • end_date — DATETIME
  • discount_date — DATETIME

membership

  • membership_id — INT — Primary key — NOT NULL
  • membership_grade — VARCHAR(50)
  • customer_id — INT
  • amount — INT
  • points — INT
  • rating — DOUBLE

order

  • order_id — INT — Primary key — NOT NULL
  • customer_id — INT
  • product_name — VARCHAR(100)
  • product_amount — INT
  • product_image — VARCHAR(300)
  • final_price — INT
  • order_date — DATETIME
  • delivery_id — INT

payment

  • payment_id — INT — Primary key — NOT NULL
  • total_price — INT
  • discount_price — INT
  • delivery_fee — INT
  • final_price — INT
  • payment_date — DATETIME
  • order_id — INT
  • points — INT

product

  • product_id — INT — Primary key — NOT NULL
  • product_name — VARCHAR(50)
  • product_price — INT
  • product_image — VARCHAR(300)
  • product_description — VARCHAR(100)
  • category_name — VARCHAR(20)
  • scale — DOUBLE
  • product_date — DATETIME
  • product_qr — VARCHAR(300)
  • discount_id — INT

review

  • product_id — INT — Primary key — NOT NULL
  • contents — VARCHAR(300)
  • review_image — VARCHAR(300)
  • rating — DOUBLE