unistage
Tables (3)
Performance (Untitled3)
- ID (Per_ID) — int — Primary key — NOT NULL
- artist (Per_artist) — char
- account (Per_account) — char
- description (Per_description) — char
- date (Per_date) — int
- location (Per_location) — char
- latitude (Per_latitude) — int
- longitude (Per_longitude) — int
- cover_image (Per_image) — url
- created_by (Per_created_by) — char
- created_at (Per_created_at) — int
- price (Per_price) — int
Ticket (Untitled2)
- ID (Ticket_ID) — Primary key — NOT NULL
- ID (User_ID) — int — Foreign key → User.ID — NOT NULL
- ID (Per_ID) — int — Foreign key → Performance.ID — NOT NULL
User (Untitled)
- ID (User_ID) — int — Primary key — NOT NULL
- email (User_email) — char
- password (User_password) — char
- nickname (User_nickname) — char