Artweek

Tables (7)

Classic (CopyOfCopyOfCopyOfUntitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Complex (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Concert (CopyOfCopyOfUntitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Exhibition (CopyOfUntitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Musical (Untitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Play (CopyOfCopyOfCopyOfCopyOfUntitled)

  • idShow (Key) — INT — Primary key — NOT NULL
  • eventID (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • idTheater (Key3) — INT — Foreign key → Theater.idTheater — NOT NULL
  • theaterId (Key22) — VARCHAR(45) — Foreign key → Theater.theaterId — NOT NULL
  • title (Field) — VARCHAR(100)
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field4) — DATE
  • location (Field5) — VARCHAR(200)
  • address (Field6) — VARCHAR(200)
  • locationID (Field10) — VARCHAR(100)
  • director (Field7) — VARCHAR(200)
  • performer (Field11) — VARCHAR(200)
  • eventStatus (Field9) — VARCHAR(200)
  • fee (Field16) — VARCHAR(200)
  • age (Field17) — VARCHAR(200)
  • timeTable (Field15) — VARCHAR(200)
  • type (Field8) — VARCHAR(45)
  • latitude (Field12) — DOUBLE
  • longitude (Field13) — DOUBLE
  • imgUrl (Field14) — VARCHAR(200)

Theater (Untitled2)

  • idTheater (Key) — INT — Primary key — NOT NULL
  • theaterId (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • name (Field) — VARCHAR(45)
  • address (Field2) — VARCHAR(200)
  • latitude (Field3) — DOUBLE
  • longitude (Field4) — DOUBLE