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