Checkmate_english
Tables (7)
Goal Ticket (goal_info)
- Goal ID (goal_id) — int — Primary key — NOT NULL
- Belonging Goal list ID (goal_list_id) — int — Foreign key → Goal list info.Goal list Unique ID — NOT NULL
- Goal end date (goal_date) — Datetime
Goal list info (goal_list)
- Goal list Unique ID (goal_list_id) — int — Primary key — NOT NULL
- Goal interval start date (goal_start) — datetime
- Goal interval (day) (goal_interval) — int
- Goal interval end date (goal_end) — datetime
- Goal name (name) — varchar(100)
- Goal description (desc) — varchar(200)
Group (group)
- Group's ID (group_id) — int — Primary key — NOT NULL
- Manager's ID (admin_id) — varchar(20) — Foreign key → User.User ID — NOT NULL
- Group name (name) — varchar(100)
- Group description (desc) — varchar(200)
- Is group public? (is_public) — int
- Group password (password) — varchar(255)
Group-Goal Table (goal_belong)
- Group's ID (group_id) — int — Foreign key → Group.Group's ID — NOT NULL
- Goal's ID (goal_id) — int — Foreign key → Goal list info.Goal list Unique ID — NOT NULL
Group-Member Table (member_belong)
- Group's ID (group_id) — int — Foreign key → Group.Group's ID — NOT NULL
- User's ID (member_id) — varchar(20) — Foreign key → User.User ID — NOT NULL
User (member)
- User ID (member_id) — varchar(20) — Primary key — NOT NULL
- User password (password) — varchar(255)
- User nickname (nickname) — varchar(255)
- User email (email) — varchar(255)
- User phone (phone) — varchar(255)
User-Goal Achieve Table (goal_acquired)
- User ID (member_id) — varchar(20) — Foreign key → User.User ID — NOT NULL
- Goal ID (goal_id) — int — Foreign key → Goal Ticket.Goal ID — NOT NULL