<ROOT guid="" versionNo="" releaseNo="" dateCreated="" timeCreated="" dateFrom="" dateTo="">

  <SITE serialNo="" siteName="" circuitNo="" circuitName"">

     <MOVIES>                        

        <CINEMATYPES>

           <CINEMATYPE cinemaTypeNo="" name="" />

        </CINEMATYPES>

        <CINEMAS>

           <CINEMA name="" cinemaNo="" cinemaId="" cinemaTypeNo="" />

        </CINEMAS>

        <FILMS>

           <FILM name="" shortName="" filmNo="" filmCode="" duration="" rating="" noFreeList="" />

        </FILMS>

        <DATES>

           <DATE asInteger="" asText="">            

              <SESSIONS filmNo="">

                 <SESSION time="" sessionNo="" filmNo="" cinemaNo="">

              </SESSIONS>                                 

           </DATE>

        </DATES>

     </MOVIES>

  </SITE>

</ROOT>

Element

Attribute

Type

Rule

ROOT

guid

string

uniqueID/ new guid string created

versionNo

integer

Showcase Software build#

releaseNo

integer

incrementing number

dateCreated

text

timeCreated

text

dateFrom

text

dateTo

text

site

serialNo

string

uniqueId supplied by Support

siteNo

integer

supplied by support

siteName

text

supplied by support

circuitNo

integer

supplied by support

circuitName

text

supplied by support

movies

N/A

cinemaTypes

N/A

cinemaType

name

text

cinemaTypeNo

integer

cinemas

N/A

cinema

name

text

cinemaNo

integer

> 0, unique, primary key

cinemaId

text

text value for cinemaNo where different i.e. REG1

cinemaTypeNo

integer

cinemaType

films

N/A

film

name

text

shortName

text

maxLen:20. used for LED Door signs, etc

filmNo

integer

> 0, unique, primary key

filmCode

text

duration

integer

minutes

rating

text

rating

noFreeList

boolean

dates

N/A

date

asInteger

integer

format YYYYMMDD

asText

text

sessions

filmNo

integer

> 0

session

time

integer

minutes

sessionNo

integer

> 0, unique, primary key

filmNo

integer

> 0

cinemaNo

integer

> 0