lettering

Tables (10)

keyring

  • id — bigint — Primary key — NOT NULL
  • is_purchase — bit(1) — NOT NULL
  • nfc_name — varchar(255) — NOT NULL
  • tag_code — varchar(255) — NOT NULL
  • design_id — bigint — Foreign key → keyring_design.id — NOT NULL
  • owner_id — bigint — Foreign key → user.id

keyring_design

  • id — bigint — Primary key — NOT NULL
  • design_name — varchar(255) — NOT NULL
  • image_url — varchar(255)
  • price — decimal(38,2) — NOT NULL

letter

  • id — bigint — Primary key — NOT NULL
  • condition_time — datetime(6)
  • condition_type — enum('NONE','RESERVATION','TIMECAPSULE') — NOT NULL
  • favorite — bit(1) — NOT NULL
  • first_opened_time — datetime(6)
  • quiz_answer — varchar(255)
  • quiz_hint — varchar(255)
  • quiz_question — varchar(255)
  • sent_time — datetime(6) — NOT NULL
  • sealing_wax_id — bigint — Foreign key → sealing_wax.id — NOT NULL
  • sender_id — bigint — Foreign key → user.id — NOT NULL

letter_content

  • id — bigint — Primary key — NOT NULL
  • text — varchar(3000) — NOT NULL
  • letter_id — bigint — Foreign key → letter.id — NOT NULL

letter_image

  • id — bigint — Primary key — NOT NULL
  • image_url — varchar(255) — NOT NULL
  • letter_id — bigint — Foreign key → letter.id — NOT NULL

postcard

  • id — bigint — Primary key — NOT NULL
  • condition_time — datetime(6)
  • condition_type — enum('NONE','RESERVATION','TIMECAPSULE') — NOT NULL
  • content — varchar(3000) — NOT NULL
  • favorite — bit(1) — NOT NULL
  • first_opened_time — datetime(6)
  • image_url — varchar(255) — NOT NULL
  • quiz_answer — varchar(255)
  • quiz_hint — varchar(255)
  • quiz_question — varchar(255)
  • sent_time — datetime(6) — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

received_letter

  • id — bigint — Primary key — NOT NULL
  • emoji_type — enum('ANGRY','HAPPY','LOVE','SAD') — NOT NULL
  • favorite — bit(1) — NOT NULL
  • open_time — datetime(6)
  • reply_sent_time — datetime(6) — NOT NULL
  • reply_text — text — NOT NULL
  • keyring_id — bigint — Foreign key → keyring.id — NOT NULL
  • letter_id — bigint — Foreign key → letter.id — NOT NULL

received_postcard

  • id — bigint — Primary key — NOT NULL
  • emoji_type — enum('ANGRY','HAPPY','LOVE','SAD') — NOT NULL
  • favorite — bit(1) — NOT NULL
  • open_time — datetime(6)
  • reply_sent_time — datetime(6) — NOT NULL
  • reply_text — text — NOT NULL
  • keyring_id — bigint — Foreign key → keyring.id — NOT NULL
  • postcard_id — bigint — Foreign key → postcard.id — NOT NULL

sealing_wax

  • id — bigint — Primary key — NOT NULL
  • image_count — int — NOT NULL
  • image_url — varchar(255) — NOT NULL
  • sealing_wax_name — varchar(255) — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • detail_address — varchar(255)
  • email — varchar(255) — NOT NULL
  • font — enum('ARIAL','COURIER','ROBOTO','TIMES')
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(255)
  • provider — varchar(255)
  • real_name — varchar(255)
  • road_address — varchar(255)
  • user_nickname — varchar(255) — NOT NULL