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