test

Tables (10)

Carpools (Untitled9)

  • carpool_id — number — Primary key — NOT NULL
  • username (driver) — string — Foreign key → Users.username — NOT NULL
  • event_id — number — Foreign key → Events.event_id — NOT NULL
  • limit — number
  • pickup_time — Date
  • destination — string
  • pickup_spot — string

Comments (Untitled8)

  • ID — number — Primary key — NOT NULL
  • event_id — number — Foreign key → Events.event_id — NOT NULL
  • username — string — Foreign key → Users.username — NOT NULL
  • contents — string

Events (Untitled7)

  • event_id — number — Primary key — NOT NULL
  • group_id — number — Foreign key → Groups.group_id — NOT NULL
  • username — string — Foreign key → Users.username — NOT NULL
  • title — string
  • contents — string
  • datetime — Date
  • location — string

Events_Tags (Untitled10)

  • ID — number — Primary key — NOT NULL
  • event_id — number — Foreign key → Events.event_id — NOT NULL
  • tag_id — string — Foreign key → Tags.tag_id — NOT NULL

Groups (Untitled3)

  • group_id — number — Primary key — NOT NULL
  • group_name — string
  • description — string
  • limit — number
  • password — hash
  • Field

Groups_Tags (Untitled5)

  • ID — number — Primary key — NOT NULL
  • tag_id — string — Foreign key → Tags.tag_id — NOT NULL
  • group_id — number — Foreign key → Groups.group_id — NOT NULL

Roles (Untitled2)

  • role — string — Primary key — NOT NULL

Tags (Untitled6)

  • tag_id — string — Primary key — NOT NULL

Users (Untitled)

  • username — string — Primary key — NOT NULL
  • password — hash
  • phone — string
  • email — string

Users_Groups (Untitled4)

  • ID — number — Primary key — NOT NULL
  • username — string — Foreign key → Users.username — NOT NULL
  • group_id — number — Foreign key → Groups.group_id — NOT NULL
  • role — string — Foreign key → Roles.role — NOT NULL