php-db-insert/schema.php at master · ikirker/php-db-insert · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?php
    $fields_lists = array(
      "Venue"         => array("VenueID", "VenueName", "Add1", "Add2", "Add3",
                               "LocationID", "SeatCap", "VenueTypeID",
                               "VenueDescription", "Comments"),
      "VenueType"     => array("VenueTypeID", "VenueTypeName"),
      "VenueResource" => array("UID", "VenueID", "SourceID"),
      "Location"      => array("LocationID", "XCoordinate", "YCoordinate"),
      "CompanyVenue"  => array("UID", "CompanyID", "VenueID", "RoleDescription",
                               "RoleTypeID", "RoleStartDate", "SourceID",
                               "SourcePageRef", "Comments"),
      "Company"       => array("CompanyID", "CompanyName",
                               "CompanyDescription", "Comments"),
      "PersonVenue"   => array("UID", "PersonID", "VenueID", "RoleDescription",
                               "RoleTypeID", "RoleStartDate", "SourceID",
                               "SourcePageRef", "Comments"),
      "Person"        => array("PersonID", "PSurname", "PMiddleName", "PFname",
                               "PTitle", "Gender", "DoB", "DoD", "PDescription",
                               "Comments"),
      "RoleType"      => array("RoleTypeID", "RoleTypeName"),
      "Events"        => array("EventID", "VenueID", "EventDate", "EventTypeID",
                               "EventDescription", "SourceID", "SourcePageRef",
                               "Comments"),
      "EventType"     => array("EventTypeID", "EventTypeName"),
      "Source"        => array("SourceID", "SourceTypeID", "SourceName", "AuthSurname", "AuthFName", "SourceYear", "SourcePlPub", "SourcePub", "SourceLocation", "Comments"),
      "SourceType"    => array("SourceTypeID", "SourceTypeName"),
    );


    $table_list = array_keys($fields_lists);

?>