25_03_27_OrderERD
Tables (4)
items (Untitled2)
- id (Key) — BIGINT(10) — Primary key — NOT NULL
- name (Field) — VARCHAR(100) — NOT NULL
- category (Field2) — VARCHAR(50)
- price (Field4) — FLOAT — NOT NULL
- create_date (Field3) — DATETIME
member
- id (Key) — BIGINT(10) — Primary key — NOT NULL
- name (Field) — VARCHAR(20) — NOT NULL
- password (Field2) — VARCHAR(20) — NOT NULL
- nickname (Field3) — VARCHAR(30)
- address (Field4) — VARCHAR(300)
- join_date (Field5) — DATETIME — NOT NULL
order_item (Untitled3)
- id (Key3) — BIGINT(10) — Primary key — NOT NULL
- order_id (Key) — BIGINT(10) — Foreign key → orders.id — NOT NULL
- item_id (Key2) — BIGINT(10) — Foreign key → items.id — NOT NULL
orders (Untitled)
- id (Key) — BIGINT(10) — Primary key — NOT NULL
- member_id (Key2) — BIGINT(10) — Foreign key → member.id — NOT NULL
- title (Field) — VARCHAR(200) — NOT NULL
- price (Field2) — FLOAT — NOT NULL
- create_date (Field3) — DATETIME — NOT NULL