Turip ERD
Tables (16)
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)
- duration_days (업로드 날짜) — int
- duration_nights (Field) — int
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 (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
Member (Untitled14)
- id (Key) — bigint — Primary key — NOT NULL
- device_fid (Field) — varchar(255)
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)
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)
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
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
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
TripCourse (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
TripDay (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- day (Field) — int