ㅁㅁ
Tables (9)
Category
- id — INT
- name — VARCHAR(255) — NOT NULL
- memberId — INT — 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 — NOT NULL
- createdAt — DATETIME
Member
- id — INT
- kakaoUserId — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- img — VARCHAR(255)
- email — VARCHAR(255)
- alarm — TINYINT(1)
- mode — VARCHAR(255)
- sound — VARCHAR(255)
MemberFlower
- memberId — INT — Primary key — NOT NULL
- flowerId — INT — Primary key — NOT NULL
- unlocked — TINYINT(1)
MemberFriend
- memberId — INT — Primary key — NOT NULL
- friendId — INT — Primary key — NOT NULL
MemberMission
- id — INT
- memberId — INT — NOT NULL
- missionId — INT — NOT NULL
- startDate — DATETIME
- completed — TINYINT(1)
- lastUpdated — DATETIME
Mission
- id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- flowerId — INT
- targetValue — INT — NOT NULL
ProfileDetail
- id — INT
- memberId — INT — NOT NULL
- bio — TEXT