F205

Tables (11)

assets

  • id — BIGSERIAL
  • asset_key — TEXT — NOT NULL
  • asset_type — VARCHAR(30) — NOT NULL
  • display_order — INTEGER

board_assets

  • id — BIGSERIAL
  • board_id — BIGINT — Foreign key → wish_boards.id — NOT NULL
  • asset_type — VARCHAR(20) — NOT NULL
  • asset_key — TEXT — NOT NULL
  • slot_index — INTEGER
  • created_at — TIMESTAMP(6) — NOT NULL

notice_images

  • id — BIGSERIAL
  • notice_id — BIGINT — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — INTEGER — NOT NULL

notices

  • id — BIGSERIAL
  • title — VARCHAR(255) — NOT NULL
  • banner_text — VARCHAR(255)
  • is_pinned — BOOLEAN — NOT NULL
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

rolling_paper_comments

  • id — BIGSERIAL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • rolling_paper_id — BIGINT — Foreign key → rolling_papers.id
  • user_id — BIGINT — Foreign key → users.id
  • is_user — BOOLEAN — NOT NULL
  • sender_name — VARCHAR(8) — NOT NULL
  • content — TEXT — NOT NULL
  • sticker_key — TEXT
  • slot_index — INTEGER
  • guest_password — VARCHAR(255)

rolling_papers

  • id — BIGSERIAL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • slug — VARCHAR(100) — NOT NULL
  • title — VARCHAR(12) — NOT NULL
  • recipient_name — VARCHAR(100)
  • image_key — TEXT
  • target_date — DATE — NOT NULL
  • comment_token — VARCHAR(100)
  • view_token — VARCHAR(100)
  • is_comment_public — BOOLEAN — NOT NULL
  • is_saved_copy — BOOLEAN — NOT NULL
  • saved_by_user_id — BIGINT — Foreign key → users.id
  • save_source — VARCHAR(20)
  • deleted_at — TIMESTAMP

share_links

  • id — BIGSERIAL
  • short_code — VARCHAR(20) — NOT NULL
  • original_url — VARCHAR(2048) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • email — VARCHAR(100)
  • school — VARCHAR(100)
  • school_code — VARCHAR(100)
  • gender — VARCHAR(10)
  • grade — VARCHAR(20)
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL
  • team_tag — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL

wish_boards

  • id — BIGSERIAL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • board_slug — VARCHAR(100) — NOT NULL
  • title — VARCHAR(12)
  • is_public — BOOLEAN — NOT NULL
  • target_date — DATE
  • is_comment_public — BOOLEAN — NOT NULL
  • is_saved_copy — BOOLEAN — NOT NULL
  • saved_by_user_id — BIGINT — Foreign key → users.id
  • deleted_at — TIMESTAMP

wish_comments

  • id — BIGSERIAL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • wish_list_id — BIGINT — Foreign key → wish_boards.id
  • user_id — BIGINT — Foreign key → users.id
  • is_user — BOOLEAN — NOT NULL
  • sender_name — VARCHAR(8) — NOT NULL
  • sticker_key — TEXT — NOT NULL
  • slot_index — INTEGER
  • guest_password — VARCHAR(255)

wish_items

  • id — BIGSERIAL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • board_id — BIGINT — Foreign key → wish_boards.id — NOT NULL
  • slot_index — INTEGER — NOT NULL
  • item_name — VARCHAR(100)
  • like_count — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL