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