콘서트 예매 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