interpark

Tables (3)

Point

  • PointId (pointId) — INT — Primary key — NOT NULL
  • UserId (userId) — INT — Foreign key → User.UserId — NOT NULL
  • ShowId (showId) — INT — Foreign key → Show.ShowId — NOT NULL
  • Point (point) — INT
  • CreatedAt (createdAt) — DATETIME

Show

  • ShowId (showId) — INT — Primary key — NOT NULL
  • UserId (userId) — INT — Foreign key → User.UserId — NOT NULL
  • Name (name) — VARCHAR
  • Info (info) — VARCHAR
  • Datetime (datetime) — VARCHAR
  • Place (place) — VARCHAR
  • SeatInfo (seatinfo) — VARCHAR
  • Image (image) — VARCHAR
  • Category (category) — ENUM
  • CreatedAt (createdAt) — DATETIME

User

  • UserId (userId) — INT — Primary key — NOT NULL
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • Name (name) — VARCHAR
  • Role (role) — ENUM
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME