MeokPlaylist
Tables (15)
bookmarks_spot
- user_id — INTEGER — Primary key — NOT NULL
- spot_id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMPTZ
comments
- comment_id — SERIAL
- post_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- parent_id — INTEGER
- content — TEXT
follows
- follower_id — INTEGER — Primary key — NOT NULL
- followee_id — INTEGER — Primary key — NOT NULL
- created_at — TIMESTAMPTZ
- CHECK — (follower_id <> followee_id)
notifications
- noti_id — SERIAL
- user_id — INTEGER — NOT NULL
- type — notification_type — NOT NULL
- post_id — INTEGER
- is_read — BOOLEAN
- created_at — TIMESTAMPTZ
oauth_providers
- provider_id — SMALLSERIAL
- name — VARCHAR(20) — NOT NULL
post_categories
- post_id — INTEGER — Primary key — NOT NULL
- category_id — INTEGER — Primary key — NOT NULL
post_photos
- post_id — INTEGER — Primary key — NOT NULL
- photo_id — BIGINT — Primary key — NOT NULL
- seq — INTEGER — NOT NULL
posts
- post_id — SERIAL
- user_id — INTEGER — NOT NULL
- content — TEXT
- created_at — TIMESTAMPTZ
spot_categories
- spot_id — BIGINT — Primary key — NOT NULL
- category_id — INTEGER — Primary key — NOT NULL
terms
- version — VARCHAR(20)
- url — TEXT — NOT NULL
- published_at — DATE — NOT NULL
trip_days
- day_id — SERIAL
- trip_id — INTEGER — NOT NULL
- trip_date — DATE — NOT NULL
trip_spots
- ts_id — SERIAL
- trip_id — INTEGER — NOT NULL
- spot_id — BIGINT
- seq — INTEGER — NOT NULL
- est_arrival — TIMESTAMPTZ
- est_departure — TIMESTAMPTZ
user_categories
- user_id — INTEGER — Primary key — NOT NULL
- category_id — INTEGER — Primary key — NOT NULL
user_oauth
- user_id — INTEGER — Primary key — NOT NULL
- provider_id — SMALLINT — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- provider_uid — VARCHAR(255) — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- token_exp — TIMESTAMPTZ
user_terms
- user_id — INTEGER — Primary key — NOT NULL
- version — VARCHAR(20) — Primary key — NOT NULL
- agreed_at — TIMESTAMPTZ