grad
Tables (7)
Announcement (Untitled5)
- announcement_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
- group_id (Key3) — Foreign key → Soccer_group.group_id — NOT NULL
- title (Field)
- content (Field2)
- created_time (Field3)
Join_request (Untitled3)
- request_id (Key) — Primary key — NOT NULL
- group_id (Key2) — Foreign key → Soccer_group.group_id — NOT NULL
- user_id (Field)
- request_time (Field2)
Meeting (Untitled7)
- meeting_id (Key) — Primary key — NOT NULL
- group_id (Key2) — Foreign key → Soccer_group.group_id — NOT NULL
- meeting_name (Field)
- meeting_date (Field2)
- meeting_location (Field3)
- meeting_time (Field4)
- meeting_category (Field5)
- x_coordinate (Field6)
- y_coordinate (Field7)
Members (Untitled4)
- group_id (Key2) — Foreign key → Soccer_group.group_id — NOT NULL
- user_id (Key) — Foreign key → Users.user_id — NOT NULL
Soccer_group (Untitled2)
- group_id (Key) — Primary key — NOT NULL
- group_profile_img_url (Field2)
- group_name (Field3)
- group_point (Field4)
- group_region (Field5)
- group_description (Field6)
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
Users (Untitled)
- user_id (Key) — Primary key — NOT NULL
- role (Field)
- email (Field2)
- password (Field3)
- provider (Field4)
vote (Untitled6)
- vote_id (Key) — Primary key — NOT NULL
- group_id (Key2) — Foreign key → Members.group_id — NOT NULL
- user_id (Key3) — Foreign key → Members.user_id — NOT NULL
- title (Field)
- created_time (Field2)