asd
Tables (16)
after_type_category
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
go_with_comment
- id — bigint — Primary key — NOT NULL
- go_with_board_id — bigint — Foreign key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- create_date — datetime(6)
- modified_date — datetime(6)
- content — text
image
- id — bigint — Primary key — NOT NULL
- review_board_id — bigint — Foreign key → review_board.id — NOT NULL
- ticket_id — bigint — Foreign key → ticket.id — NOT NULL
- attraction_id — bigint — Foreign key — NOT NULL
- event_board_id — bigint — Foreign key — NOT NULL
- go_with_board_id — bigint — Foreign key — NOT NULL
- rep_img_yn — bit(1)
- img_name — varchar(50)
- img_ori_name — varchar(50)
- img_url — varchar(100)
inventory
- id — bigint — Primary key — NOT NULL
- ticket_id — bigint — Foreign key → ticket.id — NOT NULL
- id (id2) — bigint — Foreign key → ticket.admin_id — NOT NULL
- date — date
- quantity — int — NOT NULL
member
- id — bigint — Primary key — NOT NULL
- is_suspended — bit(1)
- birth — varchar(255)
- email — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- oauth2id — varchar(255)
- password — varchar(255)
- profile_img_url — varchar(255)
- provider — varchar(255)
- provider_id — varchar(255)
- role — varchar(255)
member_coupon
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- coupon_id — bigint — Foreign key — NOT NULL
- used — bit(1) — NOT NULL
- order_id — bigint
- coupon_code — varchar(255)
notification
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- event_board_id — bigint
- coupon_id — bigint
- go_width_board_id — bigint
- order_id — bigint
- review_comment_id — bigint
- review_id — bigint
- message — varchar(255)
- type — varchar(255)
order (orders)
- order_id — bigint — Primary key — NOT NULL
- order_date — datetime(6)
- order_num — varchar(255)
- reservation_status — enum('CANCEL','PAYED','RESERVE')
order_ticket
- order_ticket_id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → order.order_id — NOT NULL
- reservation_ticket_id — bigint — Foreign key → reservation_ticket.id — NOT NULL
- id (id22) — bigint — Foreign key → reservation_ticket.id — NOT NULL
- adult_count — int
- adult_price — int
- child_count — int
- child_price — int — NOT NULL
- visit_date — date
personality_category
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
reservation
- reservation_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
reservation_ticket
- id — bigint — Primary key — NOT NULL
- reservation_id (reservation_id2) — bigint — Foreign key → reservation.reservation_id — NOT NULL
- member_id — bigint — Foreign key → reservation.member_id — NOT NULL
- ticket_id — bigint — Foreign key → ticket.id — NOT NULL
- id (id22) — bigint — Foreign key → ticket.admin_id — NOT NULL
- adult_count — int
- child_count — int
- reservation_date — datetime(6)
- reservation_status — enum('CANCEL','PAYED','RESERVE')
- visit_date — varchar(255)
review_board
- id — bigint — Primary key — NOT NULL
- author_id — bigint — Foreign key → member.id — NOT NULL
- count — int
- create_date — datetime
- modified_date — datetime
- subject — varchar(200)
- content — text
review_board_voter
- voter_id — bigint — Foreign key → member.id — NOT NULL
- review_board_id — bigint — Foreign key → review_board.id — NOT NULL
review_comment
- id — bigint — Primary key — NOT NULL
- review_board_id (id2) — bigint — Foreign key → review_board.id — NOT NULL
- id (id22) — bigint — Foreign key → review_board.author_id — NOT NULL
- author_id — bigint
- create_date — datetime(6)
- modified_date — datetime(6)
- content — text
ticket
- id — bigint — Primary key — NOT NULL
- admin_id — bigint — Foreign key → member.id — NOT NULL
- adult_price — int — NOT NULL
- child_price — int — NOT NULL
- end_date — date
- start_date — date
- reg_time — datetime(6)
- update_time — datetime(6)
- name — varchar(50)
- location_category — enum('BUSAN','SEOUL')
- memo — text
- modified_by — varchar(255)