시즈니투어
테이블 (18)
activity
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(20) — NOT NULL
member
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(255) — NOT NULL
place
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- address — varchar(255) — NOT NULL
- description — longtext — NOT NULL
- images — longtext — NOT NULL
- name — varchar(100) — NOT NULL
- point — geometry — NOT NULL
- rating — double — NOT NULL
- region_id — bigint(20) — NOT NULL
- title — varchar(200) — NOT NULL
- visit_date — char(8) — NOT NULL
place_activity
- activity_id — bigint(20) — 기본 키 — NOT NULL
- place_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
place_like
- place_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
place_type
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(50) — NOT NULL
place_type_group
- place_id — bigint(20) — 기본 키 — NOT NULL
- place_type_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
place_unit
- place_id — bigint(20) — 기본 키 — NOT NULL
- unit_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
region
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(20) — NOT NULL
- upper_region_id — bigint(20)
tag
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(100) — NOT NULL
tag_place
- place_id — bigint(20) — 기본 키 — NOT NULL
- tag_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
tour
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- favorites — int(11) — NOT NULL
- from — datetime — NOT NULL
- is_done — bit(1) — NOT NULL
- name — varchar(50) — NOT NULL
- recommends — int(11) — NOT NULL
- region_id — bigint(20) — NOT NULL
- scope — varchar(255)
- to — datetime — NOT NULL
tour_notification
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- scheduled_at — datetime — NOT NULL
- sended_at — datetime
- tour_id — bigint(20) — NOT NULL
- user_id — binary(255) — NOT NULL
tour_place
- place_id — bigint(20) — 기본 키 — NOT NULL
- tour_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- budget — int(11) — NOT NULL
- description — varchar(255) — NOT NULL
- from — datetime — NOT NULL
- to — datetime — NOT NULL
tourist
- tour_id — bigint(20) — 기본 키 — NOT NULL
- user_id — binary(255) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
unit
- id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- name — varchar(20) — NOT NULL
unit_member
- member_id — bigint(20) — 기본 키 — NOT NULL
- unit_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
user
- id — varchar(255) — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
- display_name — varchar(30) — NOT NULL
- email — varchar(100) — NOT NULL
- fcm_token — varchar(200)
- role — varchar(255)
- twitter_id — varchar(30)