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