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