TRAVELERS
Tables (13)
anonymous_member
- anonymous_member_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- reservation_code — varchar(255)
- tel — varchar(255)
- username — varchar(255)
anonymous_reservation
- reservation_id — bigint — Primary key — NOT NULL
- code — varchar(255)
- adult — int
- infant — int
- kid — int
- payment — bigint
- status — varchar(255)
- when_departure — varchar(255)
- when_return — varchar(255)
- departure_id — bigint — Foreign key → departure.departure_id
- anonymous_member_id — bigint — Foreign key → anonymous_member.anonymous_member_id
banner
- banner_id — bigint — Primary key — NOT NULL
- hashtag — varchar(255)
- image — varchar(255)
- title — varchar(255)
- product_id — bigint — Foreign key → product.product_id
departure
- departure_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- cur_capacity — int
- max_capacity — int
- min_capacity — int
- remain_capacity — int
- status — varchar(255)
- when_departure — varchar(255)
- when_return — varchar(255)
- product_id — bigint — Foreign key → product.product_id
image
- image_id — bigint — Primary key — NOT NULL
- image_type — varchar(31) — NOT NULL
- image_key — varchar(255)
- image_url — varchar(255)
- member_id — bigint — Foreign key → member.member_id
- notify_id — bigint — Foreign key → notify.notify_id
- product_id — bigint — Foreign key → product.product_id
- qna_id — bigint — Foreign key → qna.qna_id
- review_id — bigint — Foreign key → review.review_id
member
- member_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- area — varchar(255)
- authority — varchar(255)
- birth — varchar(255)
- email — varchar(255)
- gender — varchar(255)
- group_trip — varchar(255)
- password — varchar(255)
- recommend — varchar(255)
- recommend_code — varchar(255)
- tel — varchar(255)
- theme — varchar(255)
- username — varchar(255)
notify
- notify_id — bigint — Primary key — NOT NULL
- d_type — varchar(31) — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- content — longtext — NOT NULL
- title — varchar(255) — NOT NULL
- type — varchar(255)
- sequence — bigint
- member_id — bigint — Foreign key → member.member_id — NOT NULL
product
- product_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- area — varchar(255)
- period — int
- adult — bigint
- infant — bigint
- kid — bigint
- start_date — longtext
- summary — varchar(255)
- target — varchar(255)
- theme — varchar(255)
- title — varchar(255)
qna
- qna_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- content — longtext — NOT NULL
- title — varchar(255) — NOT NULL
- reply_cnt — int
- status — varchar(255)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
reply
- reply_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- content — longtext
- qna_id — bigint — Foreign key → qna.qna_id
- member_id — bigint — Foreign key → member.member_id
reservation
- reservation_id — bigint — Primary key — NOT NULL
- code — varchar(255)
- adult — int
- infant — int
- kid — int
- payment — bigint
- status — varchar(255)
- when_departure — varchar(255)
- when_return — varchar(255)
- departure_id — bigint — Foreign key → departure.departure_id
- member_id — bigint — Foreign key → member.member_id
review
- review_id — bigint — Primary key — NOT NULL
- created_at — varchar(255)
- modified_at — varchar(255)
- content — longtext — NOT NULL
- title — varchar(255) — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- product_id — bigint — Foreign key → product.product_id
travel_place
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id
- product_id — bigint — Foreign key → product.product_id