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