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 배열