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)