투리브
테이블 (15)
accommodation
- id — bigint — 기본 키 — NOT NULL
- content_id — varchar(255) — NOT NULL
- title — varchar(255)
- addr1 — varchar(255)
- addr2 — varchar(255)
- areaCode — varchar(50)
- siGunGuCode — varchar(50)
- cat1 — varchar(50)
- cat2 — varchar(50)
- cat3 — varchar(50)
- imageUrl — varchar(255)
- thumbnailImageUrl — varchar(255)
- mapX — double
- mapY — double
- mLevel — int
- tel — varchar(50)
- createdTime — varchar(255)
- modifiedTime — varchar(255)
- tour_region_id — bigint — 외래 키 → tour_region.id
- place_category_id — bigint — 외래 키 → place_category.id
board
- id — bigint — 기본 키 — NOT NULL
- title — varchar(50) — NOT NULL
- content — mediumtext — NOT NULL
- member_id — bigint — 외래 키 → member.id — NOT NULL
- boardHits — int — NOT NULL
- theme — varchar(255) — NOT NULL
- region — varchar(255) — NOT NULL
- thumbnailPublicUrl — varchar(255)
- created_at — datetime
- updated_at — datetime
chat_message
- id — bigint — 기본 키 — NOT NULL
- group_id — bigint — 외래 키 → user_groups.id — NOT NULL
- sender_id — bigint — 외래 키 → member.id — NOT NULL
- type — varchar(50) — NOT NULL
- content — text
- created_at — datetime
- updated_at — datetime
comment
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → member.id — NOT NULL
- commentContent — varchar(255) — NOT NULL
- parentcomment_id — bigint — 외래 키 → comment.id
- board_id — bigint — 외래 키 → board.id
- created_at — datetime
- updated_at — datetime
group_announcement
- id — bigint — 기본 키 — NOT NULL
- user_groups_id — bigint — 외래 키 → user_groups.id — NOT NULL
- writerName — varchar(255)
- title — text — NOT NULL
- content — text
- timeStamp — datetime — NOT NULL
group_invitation
- id — bigint — 기본 키 — NOT NULL
- invitationCode — varchar(255) — NOT NULL
- user_groups_id — bigint — 외래 키 → user_groups.id — NOT NULL
- createdAt — datetime — NOT NULL
- expiresAt — datetime — NOT NULL
- active — tinyint(1) — NOT NULL
member
- id — bigint — 기본 키 — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- profile_image_url — varchar(255)
- role — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- passwordChangedAt — datetime
- policyAgreed — tinyint(1) — NOT NULL
- subscribed — tinyint(1) — NOT NULL
- oauthProvider — varchar(50)
- created_at — datetime
- updated_at — datetime
place_category
- id — bigint — 기본 키 — NOT NULL
- cat3 — varchar(50) — NOT NULL
- contentTypeId — varchar(50)
- cat1 — varchar(50)
- cat2 — varchar(50)
- large_classification — varchar(100)
- mid_classification — varchar(100)
- small_classification — varchar(100)
- theme — varchar(100)
restaurant
- id — bigint — 기본 키 — NOT NULL
- content_id — varchar(255) — NOT NULL
- title — varchar(255)
- addr1 — varchar(255)
- addr2 — varchar(255)
- areaCode — varchar(50)
- siGunGuCode — varchar(50)
- cat1 — varchar(50)
- cat2 — varchar(50)
- cat3 — varchar(50)
- imageUrl — varchar(255)
- thumbnailImageUrl — varchar(255)
- mapX — double
- mapY — double
- mLevel — int
- tel — varchar(50)
- createdTime — varchar(255)
- modifiedTime — varchar(255)
- tour_region_id — bigint — 외래 키 → tour_region.id
- place_category_id — bigint — 외래 키 → place_category.id
schedule
- id — bigint — 기본 키 — NOT NULL
- startSchedule — datetime — NOT NULL
- endSchedule — datetime — NOT NULL
- group_id — bigint — 외래 키 → user_groups.id — NOT NULL
- created_at — datetime
- updated_at — datetime
schedule_place
- id — bigint — 기본 키 — NOT NULL
- schedule_id — bigint — 외래 키 → schedule.id — NOT NULL
- contentId — varchar(255) — NOT NULL
- placeType — varchar(50) — NOT NULL
- visitStart — datetime — NOT NULL
- visitedEnd — datetime — NOT NULL
- dayOrder — int — NOT NULL
- orderInDay — int — NOT NULL
- created_at — datetime
- updated_at — datetime
tour_region
- id — bigint — 기본 키 — NOT NULL
- areaCode — varchar(50)
- areaName — varchar(100)
- siGunGuCode — varchar(50)
- siGunGuName — varchar(100)
- region — varchar(100)
tourist_spot
- id — bigint — 기본 키 — NOT NULL
- content_id — varchar(255) — NOT NULL
- title — varchar(255)
- addr1 — varchar(255)
- addr2 — varchar(255)
- areaCode — varchar(50)
- siGunGuCode — varchar(50)
- cat1 — varchar(50)
- cat2 — varchar(50)
- cat3 — varchar(50)
- imageUrl — varchar(255)
- thumbnailImageUrl — varchar(255)
- mapX — double
- mapY — double
- mLevel — int
- tel — varchar(50)
- createdTime — varchar(255)
- modifiedTime — varchar(255)
- tour_region_id — bigint — 외래 키 → tour_region.id
- place_category_id — bigint — 외래 키 → place_category.id
user_groups
- id — bigint — 기본 키 — NOT NULL
- groupName — varchar(255) — NOT NULL
- created_by — bigint — 외래 키 → member.id — NOT NULL
- description — varchar(255)
- created_at — datetime
- updated_at — datetime
user_groups_members
- user_groups_id — bigint — 외래 키 → user_groups.id — NOT NULL
- user_id — bigint — 외래 키 → member.id — NOT NULL