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