asw_이쁜거
테이블 (19)
ai_keyword
- id — bigint — 기본 키 — NOT NULL
- keyword — varchar(100) — NOT NULL
comments
- id — bigint — 기본 키 — NOT NULL
- question_ref_id — bigint — 외래 키 → question_reference.id — NOT NULL
- writer — bigint — 외래 키 → users.id — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- content — text — NOT NULL
- reply_to — bigint — 외래 키 → comments.id
- likes — int — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
families
- id — bigint — 기본 키 — NOT NULL
- verification_code — varchar(100) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
flower_catalog
- id — bigint — 기본 키 — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- flower_type — enum('camellia','rose','acacia','hydrangea','plum_blossom','tulip','pear_blossom','violet','cherry_blossom','cosmos','magnolia','sunflower') — NOT NULL
- unlocked — tinyint(1)
- unlocked_at — timestamp
flowers
- id — bigint — 기본 키 — NOT NULL
- tree_id — bigint — 외래 키 → tree.id — NOT NULL
- question_ref_id — bigint — 외래 키 → question_reference.id
- flower — enum('camellia','rose','acacia','hydrangea','plum_blossom','tulip','pear_blossom','violet','cherry_blossom','cosmos','magnolia','sunflower') — NOT NULL
- created_at — timestamp
fruit_catalog
- id — bigint — 기본 키 — NOT NULL
- unlocked — tinyint(1)
fruits
- id — bigint — 기본 키 — NOT NULL
- tree_id — bigint — 외래 키 → tree.id — NOT NULL
- created_at — timestamp
- puzzle_id — int — 외래 키 → puzzle.puzzle_id
- message — varchar(255)
- fruit_name — varchar(100)
- category — varchar(50) — NOT NULL
- contributors — json
- last_saved_time — datetime
- completed_pieces_id — json
island_archives
- id — bigint — 기본 키 — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- capture_image_path — varchar(255) — NOT NULL
- month — int — NOT NULL
- year — int — NOT NULL
- created_at — timestamp
- period — int — NOT NULL
- puzzle_score — integer — NOT NULL
- community_score — integer — NOT NULL
likes
- id — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → users.id — NOT NULL
- target_type — enum('question','public_question','comment') — NOT NULL
- target_id — bigint — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- created_at — timestamp
personal_questions
- id — bigint — 기본 키 — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- content — text — NOT NULL
- sender — bigint — 외래 키 → users.id — NOT NULL
- receiver — bigint — 외래 키 → users.id — NOT NULL
- visibility — tinyint(1)
- solved — tinyint(1)
- likes — int
- created_at — timestamp
- updated_at — timestamp
public_questions
- id — bigint — 기본 키 — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- content — text — NOT NULL
- likes — int — NOT NULL
- counts — int — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
puzzle
- puzzle_id — int — 기본 키 — NOT NULL
- image_path — varchar(255) — NOT NULL
- capture_image_path — varchar(255)
- size — int
- completed_pieces_id — json
- completed — tinyint(1) — NOT NULL
- is_playing_puzzle — tinyint(1) — NOT NULL
- be_puzzle — tinyint(1) — NOT NULL
- solver_id — bigint
- contributors — json
- families_id — bigint — NOT NULL
- message — varchar(255)
- category_id — bigint — NOT NULL
- ai_keyword_id — bigint — NOT NULL
- uploader_id — bigint
- last_saved_time — datetime
- completed_time — datetime
puzzle_archive
- id — bigint — 기본 키 — NOT NULL
- image_path — varchar(255) — NOT NULL
- category — varchar(255)
- contributors — json
- families_id — bigint — NOT NULL
puzzle_category
- id — bigint — 기본 키 — NOT NULL
- category — varchar(50) — NOT NULL
puzzle_pieces
- id — bigint — 기본 키 — NOT NULL
- puzzle_id — int — 외래 키 → puzzle.puzzle_id — NOT NULL
- piece_id — varchar(50) — NOT NULL
- position — json — NOT NULL
question_list
- id — bigint — 기본 키 — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
question_reference
- id — bigint — 기본 키 — NOT NULL
- question_id — bigint — NOT NULL
- question_type — enum('Personal','Public') — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
tree
- id — bigint — 기본 키 — NOT NULL
- archive_id — bigint — 외래 키 → island_archives.id — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- created_at — timestamp
- tree_category — enum('flower','fruit') — NOT NULL
- position — int — NOT NULL
users
- id — bigint — 기본 키 — NOT NULL
- family_id — bigint — 외래 키 → families.id — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(20) — NOT NULL
- age — int
- birthday — date
- gender — enum('M','F') — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(50) — NOT NULL
- profile_photo — varchar(255)
- family_type — enum('자녀','아빠','엄마','할아버지','할머니')
- created_at — timestamp
- updated_at — timestamp