Dearly_v2
Tables (22)
edition_wishes
- user_id — UUID — Primary key — NOT NULL
- edition_id — UUID — Primary key — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
editions
- id — UUID
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR
- preview_url — VARCHAR
- typography — VARCHAR(100)
- palette — VARCHAR(255)
- mood — VARCHAR(100)
- price — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_accounts
- invitation_id — UUID — Primary key — NOT NULL
- role — VARCHAR(20) — Primary key — NOT NULL
- bank_name — VARCHAR(50)
- account_number — VARCHAR(50)
- account_holder — VARCHAR(50)
- show_kakao_pay — BOOLEAN — NOT NULL
- kakao_pay_link — VARCHAR
- show_toss — BOOLEAN — NOT NULL
- toss_link — VARCHAR
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_ceremonies
- invitation_id — UUID
- ceremony_at — TIMESTAMP
- venue_name — VARCHAR(100)
- hall_name — VARCHAR(100)
- address — VARCHAR(255)
- latitude — FLOAT
- longitude — FLOAT
- map_type — VARCHAR(20)
- show_dday — BOOLEAN — NOT NULL
- transport_info — TEXT
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_closings
- invitation_id — UUID
- is_enabled — BOOLEAN — NOT NULL
- image_url — VARCHAR
- message — TEXT
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_covers
- invitation_id — UUID
- title — VARCHAR(255)
- cover_image_url — VARCHAR
- share_image_url — VARCHAR
- kakao_image_url — VARCHAR
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_galleries
- invitation_id — UUID — Primary key — NOT NULL
- sort_order — SMALLINT — Primary key — NOT NULL
- image_url — VARCHAR — NOT NULL
- layout_type — VARCHAR(20) — NOT NULL
- allow_download — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_guestbook_entries
- id — UUID
- invitation_id — UUID — NOT NULL
- author_name — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- delete_password — VARCHAR — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
invitation_guestbook_settings
- invitation_id — UUID
- is_enabled — BOOLEAN — NOT NULL
- delete_password — VARCHAR
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_members
- invitation_id — UUID — Primary key — NOT NULL
- user_id — UUID — Primary key — NOT NULL
- role — VARCHAR(10) — NOT NULL
- invited_at — TIMESTAMPTZ
- accepted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
invitation_notices
- invitation_id — UUID — Primary key — NOT NULL
- sort_order — SMALLINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_persons
- invitation_id — UUID — Primary key — NOT NULL
- role — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(50)
- father_name — VARCHAR(50)
- mother_name — VARCHAR(50)
- phone — VARCHAR(20)
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_rsvp_responses
- id — UUID
- invitation_id — UUID — NOT NULL
- side — VARCHAR(10) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- is_attending — BOOLEAN — NOT NULL
- meal_count — SMALLINT — NOT NULL
- message — TEXT
- responded_at — TIMESTAMPTZ — NOT NULL
invitation_rsvp_settings
- invitation_id — UUID
- is_enabled — BOOLEAN — NOT NULL
- show_groom_side — BOOLEAN — NOT NULL
- show_bride_side — BOOLEAN — NOT NULL
- show_attendance_count — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_texts
- invitation_id — UUID
- title — VARCHAR(255)
- body — TEXT
- ai_generated — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitation_videos
- invitation_id — UUID
- source_type — VARCHAR(20) — NOT NULL
- youtube_url — VARCHAR
- file_url — VARCHAR
- thumbnail_url — VARCHAR
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
invitations
- id — UUID
- edition_id — UUID — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed_sections — SMALLINT — NOT NULL
- section_order — JSONB
- view_count — INT — NOT NULL
- published_at — TIMESTAMPTZ
- archived_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
refresh_tokens
- id — UUID
- user_id — UUID — NOT NULL
- token — VARCHAR — NOT NULL
- device_info — VARCHAR
- expires_at — TIMESTAMPTZ — NOT NULL
- revoked_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
social_accounts
- provider — VARCHAR(20) — Primary key — NOT NULL
- provider_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — UUID — NOT NULL
- access_token — VARCHAR
- refresh_token — VARCHAR
- token_expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
user_editions
- user_id — UUID — Primary key — NOT NULL
- edition_id — UUID — Primary key — NOT NULL
- purchased_at — TIMESTAMPTZ — NOT NULL
- amount_paid — INT — NOT NULL
user_integrations
- user_id — UUID — Primary key — NOT NULL
- service — VARCHAR(30) — Primary key — NOT NULL
- access_token — VARCHAR — NOT NULL
- refresh_token — VARCHAR
- token_expires_at — TIMESTAMPTZ
- target_folder_id — VARCHAR
- target_folder_name — VARCHAR
- is_active — BOOLEAN — NOT NULL
- connected_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID
users
- id — UUID
- nickname — VARCHAR(50)
- profile_image — VARCHAR
- email — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- updated_by — UUID