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