LeisureUp-2025.09.22

Tables (15)

AppleOAuth (apple_oauth)

  • sub — varchar(255) — Primary key — NOT NULL
  • memberId (member_id) — double — Foreign key → Member.id — NOT NULL

CatEarth (cat_earth)

  • id (category_id) — bigint — Foreign key → Category.id — NOT NULL

CatOther (cat_other)

  • id (category_id) — bigint — Foreign key → Category.id — NOT NULL

CatSky (cat_sky)

  • id (category_id) — bigint — Foreign key → Category.id — NOT NULL

CatWater (cat_water)

  • id (category_id) — bigint — Foreign key → Category.id — NOT NULL

Category (category)

  • id (category_id) — bigint — Primary key — NOT NULL
  • categoryCode (category_code) — bigint
  • categoryType (category_type) — enum(earth, water, sky, other)
  • name — varchar(50)
  • recommendingCode (recommending_code) — varchar(255)

EventPublication (event_publication)

  • id — binary — Primary key — NOT NULL
  • event_type — varchar(255)
  • listener_id — varchar(255)
  • serialized_event — varchar(255)
  • completion_date — datetime(6)
  • publication_date — datetime(6)

GoogleOAuth (google_oauth)

  • sub — varchar(255) — Primary key — NOT NULL
  • memberId (member_id) — double — Foreign key → Member.id — NOT NULL

Interest (interest)

  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • representationCode (representation_code) — varchar(255)
  • createdAt (created_at) — datetime(6)
  • modifiedAt (modified_at) — datetime(6)

Item (item)

  • id (item_id) — bigint — Primary key — NOT NULL
  • travel_id — double — Foreign key → Travel.id — NOT NULL
  • locationId (location_id) — bigint
  • position — int
  • startTime (start_time) — time(6)
  • endTime (end_time) — time(6)

KakaoOAuth (kakao_oauth)

  • sub — varchar(255) — Primary key — NOT NULL
  • memberId (member_id) — double — Foreign key → Member.id — NOT NULL

Location (location)

  • id (location_id) — bigint — Primary key — NOT NULL
  • category_id — double — Foreign key → Category.id — NOT NULL
  • gpsX (gps_x) — double — NOT NULL
  • gpsY (gps_y) — double
  • name — varchar(255)
  • contentTypeId (content_type_id) — bigint
  • thumbnailUrl (thumbnail_url) — varchar(255)
  • lastModifiedAt (last_modified_at) — datetime(6)

Member (member)

  • id (member_id) — bigint — Primary key — NOT NULL
  • nickname — varchar(50)
  • email — varchar(255)

Pick (pick)

  • location_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • createdAt (created_at) — datetime(6)

Travel (travel)

  • id (travel_id) — bigint — Primary key — NOT NULL
  • memberId — bigint
  • name — varchar(50)
  • startDate (start_date) — date
  • endDate (end_date) — date