공연장

테이블 (3)

Performance

  • Key (postId) — Int — 기본 키 — NOT NULL
  • Key (userId) — Int — 외래 키 → User.Key — NOT NULL
  • Key (admin) — Int — 외래 키 → User.Key — NOT NULL
  • Field (title) — string
  • Field2 (content) — text
  • Field4 (image) — String
  • Field (Place) — String
  • Field (seat) — String
  • Field (category) — String
  • Field (dates) — DateTime

Reservation

  • Key (reservatioId) — Int — 기본 키 — NOT NULL
  • Key (userId) — Int — 외래 키 → User.Key — NOT NULL
  • Key (admin) — INT — 외래 키 → User.Key — NOT NULL
  • reservation — string
  • Field (Place) — string
  • Field (price) — varchar

User (Untitled)

  • Key (userId) — Int — 기본 키 — NOT NULL
  • Key (admin) — Int — 기본 키 — NOT NULL
  • Field (email) — varchar
  • Field2 (password) — varchar
  • Field3 (nickname) — string
  • Field (points) — varchar