ERD
Tables (13)
AlarmType
- type_id (Key) — long — Primary key — NOT NULL
- type (Field) — enum
Alarms
- alarm_id (Key) — long — Primary key — NOT NULL
- type_id (Key3) — long — Foreign key → AlarmType.type_id — NOT NULL
- title (Field2) — varchar(20)
- content (Field) — varchar(50)
- is_read (Key2) — boolean — NOT NULL
- user_id — bigint — Foreign key → Users.user_id — NOT NULL
Banners
- banner_id (Key) — long — Primary key — NOT NULL
- img_url (Field) — varchar(100)
- title (Field2) — varchar(20)
- content (Field3) — text
HotCheck
- Hot_id (Key) — long — Primary key — NOT NULL
- place_id (Key2) — long — Foreign key → Places.place_id — NOT NULL
- week (Field) — int
- cnt (Field2) — long
Likes
- likes_id (Key2) — long — Primary key — NOT NULL
- user_id — long — Foreign key → Users.user_id — NOT NULL
- place_id (Key) — long — Foreign key → Places.place_id — NOT NULL
- Field
Medias (Untitled)
- media_id (Key) — long — Primary key — NOT NULL
- review_id (Key2) — long — Foreign key → Reviews.review_id — NOT NULL
- place_id (Key3) — long — Foreign key → Places.place_id — NOT NULL
- user_id — long — Foreign key → Reviews.user_id — NOT NULL
- url (Field) — varchar(50)
NewPlaces
- np_id (Key) — long — Primary key — NOT NULL
- name (Field) — varchar(20)
- link (Field2) — varchar(100)
- reason (Field3) — text
Notification
- noti_id (Key) — long — Primary key — NOT NULL
- date (Field) — date
- title (Field2) — varchar(20)
- content (Field3) — text
Places
- place_id (Key) — long — Primary key — NOT NULL
- name (Field7) — text
- purpose (Field) — enum 배열
- type (Field2) — enum 배열
- mood (Field3) — enum 배열
- facilities (Field4) — enum 배열
- location (Field5) — enum 배열
- is_free (Field6) — boolean
- information (Field8) — text
Points
- point_id (Key) — long — Primary key — NOT NULL
- user_id — long — Foreign key → Users.user_id — NOT NULL
- point_update (Field) — int
- date (Field2) — date
- content (Field3) — varchar(20)
RecentSearch
- search_id (Key) — long — Primary key — NOT NULL
- user_id — long — Foreign key → Users.user_id — NOT NULL
- keyword (Field) — varchar(20)
Reviews
- review_id (Key) — long — Primary key — NOT NULL
- user_id — long — Foreign key → Users.user_id — NOT NULL
- place_id (Key2) — long — Foreign key → Places.place_id — NOT NULL
- datetime (Field) — datetime
- rating (Field2) — int
- congestion (Field3) — enum
- purpose (Field4) — enum 배열
- mood (Field5) — enum 배열
- facilities (Field6) — enum 배열
- Field7 — string(500)
Users
- user_id — long — Primary key — NOT NULL
- email — varchar(30)
- nickname — varchar(12)
- profile_img — varchar(50)
- prefer_place — enum 배열
- purpose — enum 배열
- location — enum 배열