3조
테이블 (14)
artist (Untitled2)
- idx (Key) — 기본 키 — NOT NULL
- artist_name (Field)
- artist_img (Field2)
- artist_description (Field3)
- artist_type (Field4)
artist_list (Untitled4)
- id (Key) — 외래 키 → events.event_id — NOT NULL
- idx (Key2) — 외래 키 → artist.idx — NOT NULL
book_mark (Untitled10)
- user_id (Key) — 외래 키 → users.user_id — NOT NULL
- idx (Key2) — 외래 키 → artist.idx — NOT NULL
- id (Key3) — 외래 키 → events.event_id — NOT NULL
- category_code (Key4) — 외래 키 → category.category_code — NOT NULL
category (Untitled6)
- category_code (Key) — 기본 키 — NOT NULL
- category_name (Field)
community (Untitled12)
- comunity_idx (Key) — 기본 키 — NOT NULL
- title (Field)
- content (Field2)
- user_id (Key2) — 외래 키 → users.user_id — NOT NULL
- id (Key3) — 외래 키 → events.event_id — NOT NULL
events (Untitled3)
- event_id (Key) — 기본 키 — NOT NULL
- event_title (Field)
- event_description (Field5)
- start_date (Field6)
- end_date (Field7)
- price (Field8)
- category_code (Key2) — 외래 키 → category.category_code — NOT NULL
- venues_id (Key3) — 외래 키 → venues.venues_id — NOT NULL
- platform_code (Key4) — 외래 키 → platform.platform_code — NOT NULL
- ranking (Field2)
events_schedules (Untitled8)
- idx (Key) — 기본 키 — NOT NULL
- id (Key2) — 외래 키 → events.event_id — NOT NULL
- venues_id (Key3) — 외래 키 → venues.venues_id — NOT NULL
- platform_code (Key4) — 외래 키 → platform.platform_code — NOT NULL
- open_date (Field)
- ticket_url (Field2)
- openYn (Field3)
platform (Untitled5)
- platform_code (Key) — 기본 키 — NOT NULL
- platform_name (Field)
- platform_url (Field2)
reserved_ticket (Untitled7)
- user_id (Key) — 외래 키 → users.user_id — NOT NULL
- id (Key2) — 외래 키 → events.event_id — NOT NULL
- seat_num (Field)
review (Untitled13)
- review_index (Key) — 기본 키 — NOT NULL
- user_id (Key3) — 외래 키 → users.user_id — NOT NULL
- id (Key2) — 외래 키 → events.event_id — NOT NULL
- timestamp (Field)
- review (Field2)
- star_rate (Field3)
seat_info (Untitled11)
- seat_id (Key2) — 기본 키 — NOT NULL
- venues_id (Key) — 외래 키 → venues.venues_id — NOT NULL
- 360_img (Field)
- seat_num (Field2)
seat_review (Untitled14)
- seat_review_idx (Key3) — 기본 키 — NOT NULL
- user_id (Key) — 외래 키 → users.user_id — NOT NULL
- seat_id (Key2) — 외래 키 → seat_info.seat_id — NOT NULL
- timestamp (Field)
- review (Field2)
- star_rate (Field3)
users (Untitled)
- user_id (Key) — 기본 키 — NOT NULL
- email (Field2)
- password (Field)
- name (Field3)
- create_at (Field4)
- gender (Field5)
- B_date (Field6)
venues (Untitled9)
- venues_id (Key) — 기본 키 — NOT NULL
- venues_name (Field)
- venues_location (Field2)
- seat_count (Field3)
- open_time (Field4)
- close_time (Field5)