ㅇㅇ
Tables (7)
order
- ticket_count — int — NOT NULL — 티켓수
- order_price — int — NOT NULL — 총가격
- order_status — varchar(20) — NOT NULL — 상태
- ticket_id — bigint — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- ticket_id (ticket_id2) — bigint — Foreign key → ticket.ticket_id — NOT NULL
seat
- Field (id) — bigint
- Field (seat_type) — varchar(100)
- Field (seat_number) — varchar(100)
- Field (price) — bigint
seat2
- id — bigint — Primary key — NOT NULL
- seat_number — varchar(20) — NOT NULL
- seat_type — varchar(20) — NOT NULL
- price — int — NOT NULL
ticket
- ticket_id — bigint — Primary key — NOT NULL
- ticket_name — varchar(100) — NOT NULL — 티켓명
- concert_date — datetime — NOT NULL — 콘서트 날짜
- price — int — NOT NULL — 가격
- created_at — datetime — NOT NULL — 티켓발급날짜
- Field
ticket2
- ticket_id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- seat_id — bigint — NOT NULL
- uuid — varchar(15) — NOT NULL
- ticket_name — varchar(100) — NOT NULL
- concert_date — datetime — NOT NULL
- created_at — datetime — NOT NULL
- ticket_status — varchar(20) — NOT NULL
- id (user2_id) — bigint — Foreign key → user2.id — NOT NULL
- id (seat2_id) — bigint — Foreign key → seat2.id — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- login_id — varchar(20) — NOT NULL
- name — varchar(20) — NOT NULL — 유저명
- password — varchar(20) — NOT NULL — 유저 비밀번호
- address — varchar(300) — NOT NULL — 주소
- age — int — NOT NULL — 나이
- gender — tinyint — NOT NULL — 성별
- phone_number — varchar(20) — NOT NULL — 연락처
user2
- id — bigint — Primary key — NOT NULL
- login_id — varchar(20) — NOT NULL
- name — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL
- address — varchar(300) — NOT NULL
- age — int — NOT NULL
- gender — tinyint — NOT NULL
- phone_number — varchar(20) — NOT NULL