Pramisu
Tables (4)
Alarm (alarm)
- Alarm Id (alarm_id) — VARCHAR(255) — Primary key — NOT NULL
- From User Id (from_user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
- To User Id (to_user_id) — VARCHAR(255)
- Alarm Type (alarm_type) — VARCHAR(50)
- Alarm Date (alarm_date) — CHAR(8)
- Title (title) — VARCHAR(50)
- Content (content) — VARCHAR(255) — NOT NULL
- Is Read (is_read) — CHAR(1)
Friend (friend)
- User Id (user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
- Request Date (request_date) — CHAR(8)
- Is Friend (is_friend) — CHAR(1)
Quest (quest)
- Quest Id (quest_id) — VARCHAR(255) — Primary key — NOT NULL
- From User Id (from_user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
- To User Id (to_user_id) — VARCHAR(255)
- Title (title) — VARCHAR(50)
- Content (content) — VARCHAR(255) — NOT NULL
- Start Date (start_date) — CHAR(8)
- End Date (end_date) — CHAR(8)
- Is Completed (is_completed) — CHAR(1)
- Is Closed (is_closed) — CHAR(1)
User (user)
- User Id (user_id) — VARCHAR(255) — Primary key — NOT NULL
- Token (token) — VARCHAR(255)
- NickName (nickname) — VARCHAR(50)
- Profile Image (profile_image) — VARCHAR(255)