HUK

Tables (5)

Exhibition (Untitled2)

  • exhibitionId (Key) — Primary key — NOT NULL
  • title (Field)
  • startDate (Field2)
  • endDate (Field9)
  • price (Field3)
  • area (Field4)
  • placeAddr (Field5)
  • realmName (Field6)
  • place (Field7) — 미술관 이름
  • phone (Field8)
  • imgUrl (Field10)
  • createdAt (Field11)
  • updatedAt (Field12)
  • placeUrl (Field13)

Review (Untitled3)

  • reviewId (Key3) — Primary key — NOT NULL
  • userId (Key) — Foreign key → User.userId — NOT NULL
  • exhibitionId (Key2) — Foreign key → Exhibition.exhibitionId — NOT NULL
  • date (Field)
  • body (Field2) — 미술관 이름
  • createdAt (Field3)
  • updatedAt (Field4)

ReviewImage (Untitled4)

  • reviewImageId (Key) — Primary key — NOT NULL
  • reviewId (Key32) — Foreign key → Review.reviewId — NOT NULL
  • imageUrl (Field)

Ticket (Untitled5)

  • ticketId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • reviewId (Key3) — Foreign key → Review.reviewId — NOT NULL
  • tickeImageUrl (Field)

User (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • username (Field)
  • profileImage (Field2)
  • email (Field3)
  • createdAt (Field4)
  • updatedAt (Field5)