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