Turip ERD

Tables (18)

Category (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(255)

Category (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)

City (CopyOfUntitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • country_id (Key2) — bigint — Foreign key → Country.id — NOT NULL
  • province_id (Key3) — bigint — Foreign key → Province.id — NOT NULL
  • name (Field) — varchar(255)
  • image_url (Field2) — varchar(65535)

Content (CopyOfUntitled22)

  • id (아이디) — bigint — Primary key — NOT NULL
  • creator_id (아이디2) — bigint — Foreign key → Creator.id — NOT NULL
  • city_id (Key) — bigint — Foreign key → City.id — NOT NULL
  • url (영상 링크) — varchar(65535)
  • title (영상 제목) — varchar(100)

ContentPlace (CopyOfUntitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • content_id (아이디) — bigint — Foreign key → Content.id — NOT NULL
  • place_id (아이디2) — bigint — Foreign key → Place.id — NOT NULL
  • visit_day (Field) — int
  • visit_order (Field2) — int
  • time_line (Field3) — time

Country (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • image_url (Field2) — varchar(65535)

Creator (CopyOfUntitled4)

  • id (아이디) — bigint — Primary key — NOT NULL
  • profile_image (프로필 사진) — varchar(65535)
  • channel_name (채널명) — varchar(50)

FavoriteContent (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • content_id (아이디) — bigint — Foreign key → Content.id — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
  • created_at (Field) — date

FavoriteFolder (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
  • name (Field) — varchar(255)
  • is_default (Field2) — boolean

FavoritePlace (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • favorite_folder_id (Key2) — bigint — Foreign key → FavoriteFolder.id — NOT NULL
  • place_id (아이디) — bigint — Foreign key → Place.id — NOT NULL

Member (Untitled14)

  • id (Key) — bigint — Primary key — NOT NULL
  • device_fid (Field) — varchar(255)

Place (CopyOfUntitled32)

  • id (아이디) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • url (지도 링크) — varchar(65535)
  • address (주소) — varchar(255)
  • latitude (위도) — decimal(11, 8)
  • longitude (경도) — decimal(12, 8)

Place (Untitled3)

  • id (아이디) — int — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • map_url (지도 링크) — varchar(65535)
  • address (주소) — varchar(255)
  • latitude (위도) — decimal(11, 8)
  • longitude (경도) — decimal(12, 8)

PlaceCategory (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • place_id (아이디) — bigint — Foreign key → Place.id — NOT NULL
  • category_id (Key2) — bigint — Foreign key → Category.id — NOT NULL

PlaceCategory (Untitled8)

  • id (Key2) — int — Primary key — NOT NULL
  • place_id (아이디) — int — Foreign key → Place.id — NOT NULL
  • category_id (Key) — int — Foreign key → Category.id — NOT NULL

Province (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)

TripCourse (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • tripday_id (Key2) — int — Foreign key → TripDay.id — NOT NULL
  • place_id (아이디) — int — Foreign key → Place.id — NOT NULL
  • order (Field) — int

TripDay (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • day (Field) — int