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)