real real turip erd

Tables (22)

Copy Of account (CopyOfUntitled14)

  • id (Key) — bigint — Primary key — NOT NULL

Copy Of guest (CopyOfUntitled42)

  • id (Key) — bigint — Primary key — NOT NULL
  • account_id (Key2) — bigint — Foreign key → Copy Of account.id — NOT NULL
  • device_fid (Field) — varchar(255)

Copy Of member (CopyOfUntitled52)

  • id (Key) — bigint — Primary key — NOT NULL
  • account_id (Key2) — bigint — Foreign key → Copy Of account.id — NOT NULL
  • email (Field3) — varchar(255)

Copy Of refresh_token (CopyOfUntitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → Copy Of member.id — NOT NULL
  • member_id (Key22) — bigint — Foreign key → Copy Of member.account_id — NOT NULL
  • device_fid (Field) — varchar(255)
  • token_hash (Field2) — varchar(255)
  • issued_at (Field3) — datetime
  • expired_at (Field4) — datetime

account (Untitled14)

  • id (Key) — bigint — Primary key — NOT NULL

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)
  • uploaded_date (Field) — date

content_place (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)

favorite_content (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • content_id (아이디) — bigint — Foreign key → content.id — NOT NULL
  • account_id (Key2) — bigint — Foreign key → account.id — NOT NULL
  • created_at (Field) — date

favorite_folder (Untitled)

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

favorite_place (Untitled2)

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

guest (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • acoount_id (Key2) — bigint — Foreign key → account.id — NOT NULL
  • device_fid (Field) — varchar(255)

member (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • account_id (Key2) — bigint — Foreign key → account.id — NOT NULL
  • provider (Field) — varchar(255)
  • provider_id (Field2) — varchar(255)
  • email (Field3) — 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_category (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

province (Untitled11)

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

refresh_token (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key22) — bigint — Foreign key → member.account_id — NOT NULL
  • device_fid (Field) — varchar(255)
  • token_hash (Field2) — varchar(255)
  • issued_at (Field3) — datetime
  • expired_at (Field4) — datetime

social_member (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → Copy Of member.id — NOT NULL
  • member_id (Key22) — bigint — Foreign key → Copy Of member.account_id — NOT NULL
  • provider (Field) — varchar
  • provider_id (Field2) — varchar

turip_member (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → Copy Of member.id — NOT NULL
  • member_id (Key22) — bigint — Foreign key → Copy Of member.account_id — NOT NULL
  • login_id (Field) — varcahr
  • password (Field2) — varchar