최종

테이블 (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