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