220218

Tables (3)

order (주문)

  • order_num (Key) — CHAR(20) — Primary key — NOT NULL
  • user_idnum (Key22) — INT — Foreign key → user.user_idnum — NOT NULL
  • user_id (Key3) — CHAR(10) — Foreign key → user.user_id — NOT NULL
  • product_id (Key2) — INT — Foreign key → product.product_id — NOT NULL
  • order_datetime (Field) — date

product (상품)

  • product_id (Key) — INT — Primary key — NOT NULL
  • produc_name (Field) — CHAR(20)
  • price (Field2) — int
  • amount (Field3) — int
  • regdate (Field4) — date

user (사용자)

  • user_idnum (Key2) — INT — Primary key — NOT NULL
  • user_id (Key) — CHAR(10) — Primary key — NOT NULL
  • user_password (Field4) — CHAR(20)
  • user_phone (Field) — CHAR(12)
  • user_address (Field2) — VARCHAR(30)
  • user_regdate (Field3) — DATE