Garden

Tables (7)

flower_language

  • id — SERIAL
  • flower_id — INT — Foreign key → flowers.id — NOT NULL
  • language_text — VARCHAR(255) — NOT NULL

flowers

  • id — SERIAL
  • name — VARCHAR(50) — NOT NULL
  • growth_img_1 — VARCHAR(200)
  • growth_img_2 — VARCHAR(200)
  • growth_img_3 — VARCHAR(200)
  • bloom_img — VARCHAR(200)
  • wither_img — VARCHAR(200)

focus_time

  • id — SERIAL
  • category — focus_category — NOT NULL
  • target_time — INT
  • time — INT — NOT NULL
  • flower_id — INT — Foreign key → flowers.id — NOT NULL
  • member_id — INT — Foreign key → members.id — NOT NULL
  • created_at — TIMESTAMP
  • state — focus_state — NOT NULL

member_flowers

  • member_id — INT — Foreign key → members.id — NOT NULL
  • flower_id — INT — Foreign key → flowers.id — NOT NULL
  • unlocked — BOOLEAN

member_friends

  • member_id — INT — Foreign key → members.id — NOT NULL
  • friend_id — INT — Foreign key → members.id — NOT NULL
  • CHECK — (member_id <> friend_id)

members

  • id — SERIAL
  • name — VARCHAR(50) — NOT NULL
  • kakao — VARCHAR(100)
  • alarm — BOOLEAN
  • mode — VARCHAR(50)
  • sound — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

missions

  • id — SERIAL
  • description — VARCHAR(255) — NOT NULL
  • member_id — INT — Foreign key → members.id — NOT NULL
  • flower_id — INT — Foreign key → flowers.id