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