Create a gist now

Instantly share code, notes, and snippets.

anonymous /gist:1167349
Created Aug 24, 2011

What would you like to do?
schema.sql
CREATE TABLE associatedlicences
(
primarylicence INTEGER,
associatedlicence INTEGER
);
CREATE TABLE clientname
(
clientid INTEGER,
name Text,
legal_order INTEGER,
address1 Text,
address2 Text,
address3 Text);
CREATE TABLE emission
(
emissionid INTEGER,
emission Text);
CREATE TABLE emissionlimit
(
emissionlimitid INTEGER,
spectrumid INTEGER,
emissionlimittypeid INTEGER,
limitfrequency Double,
limitvalue Double,
limitgraphpoint Text);
CREATE TABLE geographicreference
(
locationid INTEGER,
georeferencetypeid INTEGER,
georeferencetype Text,
easting Double,
northing Double,
mapnumber Text,
original Text,
referenceorder INTEGER
);
CREATE TABLE issuingoffice
(
officeid INTEGER,
officecode Text,
officename Text);
CREATE TABLE licence
(
licenceid INTEGER,
managementrightid INTEGER,
clientid INTEGER,
licencetypeid INTEGER,
licencetype Text,
licencecode Text,
licencecategory Text,
licencestatusid INTEGER,
officeid INTEGER,
licencenumber INTEGER,
commencementdate TEXT,
registrationdate TEXT,
expiry_date TEXT,
sets INTEGER,
callsign Text,
renewalfee Double,
shipname Text);
CREATE TABLE licenceconditions
(
licenceid INTEGER,
licenceconditions TEXT);
CREATE TABLE licencetype
(
licencetypeid INTEGER,
licencetypeidentifier Text,
workingdescription Text);
CREATE TABLE location
(
locationid INTEGER,
locationtypeid INTEGER,
locationname Text,
locationheight INTEGER,
nominalmap Text,
nominalref Text,
longeast INTEGER,
longnorth INTEGER,
districtid INTEGER
);
CREATE TABLE managementright
(
managementrightid INTEGER,
clientid INTEGER,
mrcommencementdate TEXT,
mrregistrationdate TEXT,
mrexpirydate TEXT,
mrconditions TEXT);
CREATE TABLE mapdistrict
(
mapdistrictid INTEGER,
map Text,
district Text);
CREATE TABLE radiationpattern
(
licenceid INTEGER,
patterntypeid INTEGER,
bearingfrom Double,
bearingto Double,
bearingvalue Double
);
CREATE TABLE receiveconfiguration
(
receiveconfigurationid INTEGER,
licenceid INTEGER,
locationid INTEGER,
rxantennamake Text,
rxantennatype Text,
rxantennaheight INTEGER,
rxazimuth Double,
rxequipment Text,
mpis Double,
mpisunit Text,
wantedsignal Double,
wantedunit Text);
CREATE TABLE spectrum
(
spectrumid INTEGER,
spectrumstatusid INTEGER,
spectrumstatus Text,
spectrumlabel Text,
spectrumlow Double,
spectrumhigh Double,
licenceid INTEGER,
managementrightid INTEGER,
emissionid INTEGER,
frequency Double,
power Double,
polarisation Text,
polarisationcode Text,
serviceid INTEGER,
spectrumtypeid INTEGER,
spectrumtype Text,
startdate TEXT,
enddate TEXT,
registereddate TEXT,
spectrumremarks Text);
CREATE TABLE transmitconfiguration
(
transmitconfigurationid INTEGER,
licenceid INTEGER,
locationid INTEGER,
txantennamake Text,
txantennatype Text,
txantennaheight INTEGER,
txazimuth Double,
txequipment Text);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment