콘서트 예매 erd

테이블 (12)

Copy Of Copy Of Untitled4 (order_ticket)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (uuid) — varchar(15) — NOT NULL
  • Field (ticket_name) — varchar(100) — NOT NULL
  • Field (concert_date) — datetime — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (ticket_status) — varchar(20) — NOT NULL

Copy Of Untitled (notice)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (notice_number) — int — NOT NULL
  • Field (notice_title) — varchar(200) — NOT NULL
  • Field (notice_writer) — varchar(20) — NOT NULL
  • Field (notice_content) — text — NOT NULL
  • Field (notice_hit) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (update_at) — datetime — NOT NULL
  • Field (delete_yn) — tinyint — NOT NULL

Copy Of Untitled2 (qna)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → member.Key — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (qna_title) — varchar(100) — NOT NULL
  • Field (qna_writer) — varchar(20) — NOT NULL
  • Field (qna_content) — text — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (update_at) — datetime — NOT NULL
  • Field (delete_yn) — tinyint — NOT NULL

Copy Of Untitled3 (qna_comment)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (qna_id) — bigint — 외래 키 → Copy Of Untitled2.Key — NOT NULL
  • Field (comment_writer) — varchar(20) — NOT NULL
  • Field (comment_content) — varchar(20) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (update_at) — datetime — NOT NULL
  • Field (delete_yn) — tinyint — NOT NULL

Copy Of Untitled4 (ticket2)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → member.Key — NOT NULL
  • Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (seat_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (uuid) — varchar(15) — NOT NULL
  • Field (ticket_name) — varchar(100) — NOT NULL
  • Field (concert_place) — varchar(100) — NOT NULL
  • Field (concert_date) — datetime — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (ticket_status) — varchar(20) — NOT NULL

Untitled (event_board)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → member.Key — NOT NULL
  • Field (admin_id) — bigint — NOT NULL
  • Field (board_number) — int — NOT NULL
  • Field (board_title) — varchar(200) — NOT NULL
  • Field (board_content) — text — NOT NULL
  • Field (board_hit) — int — NOT NULL
  • Field (file_name) — varchar
  • Field (file_path) — varchar
  • Field (create_at) — datetime — NOT NULL
  • Field (update_at) — datetime — NOT NULL
  • Field (delete_yn) — tinyint — NOT NULL

Untitled (comment)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (event_board_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (comment_writer) — varchar(20) — NOT NULL
  • Field (comment_content) — varchar(20) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (update_at) — datetime — NOT NULL
  • Field (delete_yn) — tinyint — NOT NULL

Untitled (admin)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (admin_login_id) — varchar(20) — NOT NULL
  • Field (admin_name) — varchar(20) — NOT NULL
  • Field (admin_password) — varchar(20) — NOT NULL

Untitled (ticket)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (uuid) — varchar(15) — NOT NULL
  • Field (ticket_name) — varchar(100) — NOT NULL
  • Field (concert_date) — datetime — NOT NULL
  • Field (seat_number) — varchar(20) — NOT NULL
  • Field (seat_type) — varchar(20) — NOT NULL
  • Field (price) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (ticket_status) — varchar(20) — NOT NULL

Untitled (order)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (user_id) — bigint — NOT NULL
  • Field (order_ticket_id) — bigint — NOT NULL
  • Field (order_date) — datetime — NOT NULL

Untitled (seat)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (seat_number) — varchar(20) — NOT NULL
  • Field (seat_type) — varchar(20) — NOT NULL
  • Field (price) — int — NOT NULL

member (user)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (login_id) — varchar(20) — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field (password) — varchar(20) — NOT NULL
  • Field (address) — varchar(300) — NOT NULL
  • Field (age) — int — NOT NULL
  • Field (gender) — tinyint — NOT NULL
  • Field (phone_number) — varchar(20) — NOT NULL