festival
Tables (5)
BOARD
- board_id — int — Primary key — NOT NULL
- member_id — int — Foreign key → MEMBER.member_id — NOT NULL
- subject — varchar
- content — varchar
- name — varchar
- date — varchar
- views — int
- category — varchar
ITEM
- item_id — int — Primary key — NOT NULL
- name — varchar
- price — int
MEMBER
- member_id — int — Primary key — NOT NULL
- email — varchar
- password — varchar
- phone — varchar
- name — varchar
- address — varchar
ORDERS
- order_id — int — Primary key — NOT NULL
- member_id — int — Foreign key → MEMBER.member_id — NOT NULL
- create_date — varchar
ORDER_ITEM
- order_item_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → ORDERS.order_id — NOT NULL
- item_id — int — Foreign key → ITEM.item_id — NOT NULL
- count — int
- price — int