MainPage_ERD
Tables (5)
image (Untitled3)
- image_id (Key) — INT — Primary key — NOT NULL
- path (Field) — VARCHAR(255)
- perform_id (Key2) — INT — Foreign key → performances.perform_id — NOT NULL
order_details (Untitled4)
- order_detail_id (Key) — INT — Primary key — NOT NULL
- contact (Field2)
- order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL
orders (Untitled2)
- order_id (Key) — INT — Primary key — NOT NULL
- quantity (Field3) — INT
- order_date (Field4) — DATE
- total_price (Field5) — INT
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
- perform_id (Key3) — INT — Foreign key → performances.perform_id — NOT NULL
performances (Untitled)
- perform_id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR(100)
- date (Field2) — DATE
- price (Field3) — INT
- main_image_id (Field4) — INT
- description (Field5) — TEXT
users (자료형)
- user_id (Key) — VARCHAR(100) — Primary key — NOT NULL
- name (Field) — VARCHAR(30)
- password (Field2) — VARCHAR(255)
- email (Field3) — VARCHAR(100)
- address (Field4) — VARCHAR(100