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