Promisor

Tables (9)

BanDate (PersonalBanDate)

  • ban_date_id (personal_ban_date_id) — INTEGER — Primary key — NOT NULL
  • member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • date — TIMESTAMP
  • date_status — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Group (Team)

  • group_id (team_id) — INTEGER — Primary key — NOT NULL
  • leader_id (member_id) — INTEGER — Foreign key → Member.member_id — NOT NULL
  • group_name (team_name) — VARCHAR(30)
  • image_url — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

GroupMember (TeamMember)

  • Key (team_member_id) — INTEGER — Primary key — NOT NULL
  • member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • group_id (team_id) — INTEGER — Foreign key → Group.group_id — NOT NULL
  • Field (latitude) — FLOAT
  • Field2 (longitude) — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Invite

  • Key (invite_id) — INTEGER — Primary key — NOT NULL
  • member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • group_id (team_id) — INTEGER — Foreign key → Group.group_id — NOT NULL
  • accept — VARCHAR(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Member

  • member_id — INTEGER — Primary key — NOT NULL
  • email — VARCHAR(100)
  • password — TEXT
  • name — VARCHAR(30)
  • image_url — TEXT
  • phone_num (telephone) — VARCHAR(11)
  • m_point (manner_point) — INTEGER
  • location — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Promise

  • promise_id — INTEGER — Primary key — NOT NULL
  • group_id (team_id) — INTEGER — Foreign key → Group.group_id — NOT NULL
  • promise_name — VARCHAR(50)
  • date — TIMESTAMP
  • Field (place) — VARCHAR(50)
  • Field (latitude) — FLOAT
  • Field (longitude) — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Relation

  • relation_id — INTEGER — Primary key — NOT NULL
  • member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • friend_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

TotalBanDate (TeamBanDate)

  • total_ban_id (team,_ban_id) — INTEGER — Primary key — NOT NULL
  • group_id (team_id) — INTEGER — Foreign key → Group.group_id — NOT NULL
  • member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
  • date — TIMESTAMP
  • Field (date_status) — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(10)

Untitled (PersonalBanDateReason)

  • Key (personal_ban_date_reason_id) — INTEGER — Primary key — NOT NULL
  • ban_date_id (personal_ban_date_id) — INTEGER — Foreign key → BanDate.ban_date_id — NOT NULL
  • Field (reason) — VARCHAR(100)
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (status) — VARCHAR(10)