컨설팅

테이블 (7)

comments

  • id — SERIAL
  • post_id — INTEGER
  • user_id — INTEGER
  • content — TEXT — NOT NULL
  • parent_comment_id — INTEGER
  • created_at — TIMESTAMP

community_posts

  • id — SERIAL
  • user_id — INTEGER
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

likes

  • id — SERIAL
  • post_id — INTEGER
  • user_id — INTEGER
  • created_at — TIMESTAMP

reservations

  • id — SERIAL
  • user_id — INTEGER
  • schedule_id — INTEGER
  • status — VARCHAR(20)
  • payment_link — TEXT
  • created_at — TIMESTAMP

schedule_edit_invites

  • id — SERIAL
  • schedule_id — INTEGER
  • inviter_id — INTEGER
  • invitee_id — INTEGER
  • created_at — TIMESTAMP

schedules

  • id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • creator_id — INTEGER
  • is_recommended — BOOLEAN
  • is_direct_input — BOOLEAN
  • created_at — TIMESTAMP

users

  • id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • sns_link — TEXT
  • profile_image — TEXT
  • role — VARCHAR(20)
  • created_at — TIMESTAMP