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