최종
테이블 (10)
ARTICLES_TB (Untitled7)
- article_idx (Key) — INT — 기본 키 — NOT NULL
- ticket_idx (Key2) — INT — 외래 키 → TICKETS_TB.ticket_idx — NOT NULL
- title (Field) — VARCHAR(70)
- wish_date (Field3) — VARCHAR(30)
- wish_round (Field8) — VARCHAR(15)
- wish_seat (Field4) — VARCHAR(130)
- seat_url (Field9) — VARCHAR(450)
- trade_type (Field10) — INT
- contents (Field2) — VARCHAR
- views (Field5) — INT
- upload_time (Field6) — DATETIME
- like (Field7) — INT
ARTISTS_TB (Untitled2)
- artist_idx (Key) — INT — 기본 키 — NOT NULL
- artist (Field) — VARCHAR(50)
- artist_url (Field2) — VARCHAR(450)
FAVORITES_TB (Untitled6)
- favor_idx (Key) — INT — 기본 키 — NOT NULL
- artist_idx (Key2) — INT — 외래 키 → ARTISTS_TB.artist_idx — NOT NULL
- user_idx (Key3) — INT — 외래 키 → USERS_TB.user_idx — NOT NULL
REVIEW_DETAIL_TB (Untitled10)
- detail_idx (Key) — INT — 기본 키 — NOT NULL
- review_idx (Key2) — INT — 외래 키 → REVIEW_TB.review_idx — NOT NULL
- detail (Field) — VARCHAR(5)
REVIEW_TB (Untitled8)
- review_idx (Key) — INT — 기본 키 — NOT NULL
- reviewer_idx (Field) — INT
- reviewed_idx (Field2) — INT
- comment (Field3) — VARCHAR(20)
- review_date (Field4) — DATETIME
SHOWS_TB (Untitled3)
- show_idx (Key) — INT — 기본 키 — NOT NULL
- title (Field) — VARCHAR(100)
- artist (Field2) — VARCHAR(50)
- round (Field4) — VARCHAR(50)
- show_date (Field3) — VARCHAR(100)
- place (Field5) — VARCHAR(50)
- category (Field6) — VARCHAR(15)
TICKETS_TB (Untitled4)
- ticket_idx (Key) — INT — 기본 키 — NOT NULL
- ticket_url (Field) — VARCHAR(450)
- show_idx (Key3) — INT — 외래 키 → SHOWS_TB.show_idx — NOT NULL
- artist_idx (Key2) — INT — 외래 키 → ARTISTS_TB.artist_idx — NOT NULL
- ticket_date (Field2) — VARCHAR(100)
- round (Field3) — VARCHAR(50)
- seat_url (Field9) — NULL 허용
- seat_type (Field4) — INT(6)
- seat_area (Field5) — VARCHAR(40)
- seat_column (Field6) — INT
- upload_time (Field7) — DATETIME
- state (Field8) — INT
USERS_TB (Untitled)
- user_idx (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(40)
- password (Field2) — VARCHAR(18)
- salt (Field4) — VARCHAR(450)
- user_id (Field5) — VARCHAR(30)
- nickname (Field3) — VARCHAR(10)
- phone (Field6) — VARCHAR(15)
- profile_url (Field7) — VARCHAR(300)
- star (Field8) — INT(6)
- like (Field9)
- location (Field10) — VARCHAR(45)
- joined_date (Field12) — DATETIME
- drop_flag (Field13) — INT
- state (Field11) — VARCHAR(5)
USER_LIKE_TB (Untitled9)
- article_idx (Key) — INT — 외래 키 → ARTICLES_TB.article_idx — NOT NULL
- user_idx (Key2) — INT — 외래 키 → USERS_TB.user_idx — NOT NULL
USER_TICKET_TB (Untitled5)
- ticket_idx (Key) — INT — 외래 키 → TICKETS_TB.ticket_idx — NOT NULL
- user_idx (Key2) — INT — 외래 키 → USERS_TB.user_idx — NOT NULL