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)