ㅁㄴㅇ
Tables (8)
Category
- id — INT
- name — VARCHAR(255) — NOT NULL
- memberId — INT — Foreign key → Member.id — NOT NULL
Flower
- id — INT
- name — VARCHAR(255) — NOT NULL
- language — VARCHAR(255)
- FlowerImg — VARCHAR(255)
FocusTime
- id — INT
- category — VARCHAR(255) — NOT NULL
- targetTime — INT
- time — INT — NOT NULL
- flowerId — INT — NOT NULL
- memberId — INT — Foreign key → Member.id — NOT NULL
- createdAt — DATETIME
Member
- id — INT
- kakaoUserId — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- img — VARCHAR(255)
- email — VARCHAR(255)
- alarm — BOOLEAN
- mode — VARCHAR(255)
- sound — VARCHAR(255)
MemberFlower
- flowerId — INT — Primary key — NOT NULL
- memberId — INT — Foreign key → Member.id — NOT NULL
- unlocked — BOOLEAN
MemberFriend
- friendId — INT — Primary key — NOT NULL
- memberId — INT — Foreign key → Member.id — NOT NULL
MemberMission
- id — INT
- memberId — INT — Foreign key → Member.id — NOT NULL
- missionId — INT — NOT NULL
- startDate — DATETIME
- completed — BOOLEAN
- lastUpdated — DATETIME
Mission
- id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- flowerId — INT — Foreign key → Flower.id
- targetValue — INT — NOT NULL