itinera
Tables (14)
categories (CopyOfUntitled7)
- categories_id (Key) — int — Primary key — NOT NULL
- category_name (Field) — enum
comment (Untitled)
- comment_id (Key) — bigint — Primary key — NOT NULL
- post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
- member_id (Key3) — bitint — Foreign key → member.member_id — NOT NULL
- content (Field) — varchar(1000)
comment_like (Untitled6)
- comment_like_id (Key) — bigint — Primary key — NOT NULL
- comment_id (Key2) — bigint — Foreign key → comment.comment_id — NOT NULL
follow (Follow)
- follow_id (Key) — bigint — Primary key — NOT NULL
- follower (Key2) — bitint — Foreign key → member.member_id — NOT NULL
- following (Key3) — bitint — Foreign key → member.member_id — NOT NULL
itinerary (Untitled2)
- itinerary_id (Key) — bigint — Primary key — NOT NULL
- trip_id (Key2) — bigint — Foreign key → trip.trip_id — NOT NULL
- day_num (Field) — int
- note (Field2) — archer(1000)
itinerary_item (Untitled3)
- itinerary_item_id (Key) — bigint — Primary key — NOT NULL
- itinerary_id (Key2) — bigint — Foreign key → itinerary.itinerary_id — NOT NULL
- order_num (Field) — int
- transportation (Field2) — enum
- duration (Field3) — bigint
- cost (Field4) — bigint
- place_id (Key3) — bigint — Foreign key → place.place_id — NOT NULL
member (Member)
- member_id (Key) — bitint — Primary key — NOT NULL
- nickname (Field) — varchar(100)
- profile_image (Field2) — varchar(100)
- role (Field3) — enum
- provider_id (Field4) — varchar(20)
- email (Field5) — varchar(100)
place (Place)
- place_id (Key) — bigint — Primary key — NOT NULL
- categories_id (Key2) — int — Foreign key → categories.categories_id — NOT NULL
- name (Field) — varchar(100)
- location (Field2) — varchar(100)
- rating (Field3) — double
- description (Field4) — archer(1000)
post (Post)
- post_id (Key) — bigint — Primary key — NOT NULL
- member_id (Key3) — bitint — Foreign key → member.member_id — NOT NULL
- trip_id (Key2) — bigint — Foreign key → trip.trip_id — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — varchar(1000)
post_like (Untitled5)
- post_like_id (Key) — bigint — Primary key — NOT NULL
- post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
tag (CopyOfUntitled8)
- tag_id (Key) — bigint — Primary key — NOT NULL
- tag_type_id (Key2) — bigint — Foreign key → tag_type.tag_type_id — NOT NULL
- place_id (Key3) — bitint — Foreign key → place.place_id — NOT NULL
- name (Field) — varchar(100)
tag_type (Tag)
- tag_type_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(100)
- descrpition (Field2) — varchar(100)
trip (Trip)
- trip_id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bitint — Foreign key → member.member_id — NOT NULL
- title (Field) — varchar(100)
- start_date (Field2) — date
- end_date (Field3) — date
- budget (Field4) — bigint
- is_public (Field5) — boolean
trip_share (Untitled4)
- trip_share_id (Key) — bigint — Primary key — NOT NULL
- trip_id (Key2) — bigint — Foreign key → trip.trip_id — NOT NULL
- permission (Field) — enum
- shared_at (Field2) — date