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