20241129_WebServerProgrammingLecture_1
Tables (4)
order_items
- order_item_id (Key) — INT — Primary key — NOT NULL
- order_id (Field) — INT
- product_id (Field2) — INT
- quantity (Field3) — INT
- price (Field4) — INT
orders
- order_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- total_price (Field2) — INT
- order_date (Field3) — DATETIME
- order_item_id (Key2) — INT — Foreign key → order_items.order_item_id — NOT NULL
products
- id (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(255)
- description (Field2) — TEXT
- price (Field3) — DECIMAL(10,2)
- image (Field4) — VARCHAR(255)
- order_item_id (Key) — INT — Foreign key → order_items.order_item_id — NOT NULL
userinfo
- iduserinfo (PK) — INT — Primary key — NOT NULL
- userId (Field) — VARCHAR(45)
- userPw (Field2) — VARCHAR(45)
- userName (Field3) — VARCHAR(45)
- userPhoneNumber (Field4) — VARCHAR(45)
- userAddress (Field5) — VARCHAR(45)
- Field6 — VARCHAR(45)
- order_id (Key) — INT — Foreign key → orders.order_id — NOT NULL