MoAPP
Tables (7)
Family (family)
- ID — LONG — Primary key — NOT NULL
- Member_Number — INT
- Family_Name — VARCHAR
- Created_Date — DATE
Family_Member (family_member)
- ID — LONG — Primary key — NOT NULL
- User_ID — LONG — Foreign key → User.ID — NOT NULL
- Family_ID — LONG — Foreign key → Family.ID — NOT NULL
- Role — INT
- Poke_Count — INT
- Talk_Count — INT
Family_Schedule (family_schedule)
- ID — LONG — Primary key — NOT NULL
- Family_ID — LONG — Foreign key → Family.ID — NOT NULL
- Schedule_Name — VARCHAR
- Schedule_Date — DATE
Interactions (Interaction)
- ID — LONG — Primary key — NOT NULL
- dst_member_id (User_ID) — LONG — Foreign key → Family_Member.User_ID — NOT NULL
- dst_member_id (asdf) — LONG
- isChecked — BOOLEAN
- interactionType (INT) — INT
Photo (photo)
- ID — LONG — Primary key — NOT NULL
- family_ID — LONG — Foreign key → Family.ID — NOT NULL
- S3_Image_URL — VARCHAR
- Name — VARCHAR
- Created_Date — DATE
Post (post)
- ID — Primary key — NOT NULL
- Src_Member_ID — LONG — Foreign key → Family_Member.ID — NOT NULL
- Title — VARCHAR
- Context — VARCHAR
- Created_Date — DATE
User (user)
- ID — LONG — Primary key — NOT NULL
- Email — VARCHAR
- PW — VARCHAR
- Username — VARCHAR
- Nickname — VARCHAR
- Age — INT
- Gender — INT