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