ASDF
Tables (4)
AidsToNavigation (beacon)
- AtoN Info (info) — varchar(60) — Primary key
- ID Code (ID) — varchar(60) — Primary key — NOT NULL
- Date end (date_end) — date
- Date start (date_start) — date
- Period end (period_end) — date
- Infomation (Information) — varchar(60)
- Infomation in national language (Language) — varchar(60)
- Textual description in national language (description_lagnguage) — varchar(60)
- Textual description (description) — varchar(60)
- Scale minimum (scale) — integer
- Source date (source) — integer
- Source indication (soruce_indication) — integer
- Pictorial representation (pictorial) — varchar(60)
- Inspection frequency (inspection) — varchar(60)
- Inspection requirement (inspection_requirment) — varchar(60)
- Aton maintence record (aton) — varchar(60)
- Installation date (installation) — date
- Geometry (geometry) — varchar(60)
AtoN Info (beacon-info)
- AtoN Info (info2) — varchar(60) — Foreign key → AidsToNavigation.AtoN Info
- ID Code (ID) — varchar(60) — Foreign key → AidsToNavigation.ID Code — NOT NULL
- AtoN Info (aton_info) — varchar(60)
- Name (name) — varchar(60)
- Latitude (latitude) — varchar(60)
- LIngitude (tude) — varchar(60)
Generic Buoy (beacon-status)
- Buoy shape (shape) — varchar(60) — Primary key — NOT NULL
- Status (status) — varhcar(60) — Primary key
- category of special purpose mark (mark) — varchar(60)
- Colour (colour) — varchar(60)
- Field — varchar(60)
- Radar conspicuous (radar) — varchar(60)
- Navigational system of marks (marks) — varchar(60)
- AtoN Info (info) — varchar(60) — Foreign key → AidsToNavigation.AtoN Info
- ID Code (ID) — varchar(60) — Foreign key → AidsToNavigation.ID Code — NOT NULL
- Nature of construction (nature) — varchar(60)
- Object name in national language (object_name) — varchar(60)
- Object name (object) — varchar(60)
- Vertical length (vertical_length) — varchar(60)
- Vertical accuacy (vertical_accuacy) — varchar(60)
- Type of buoy (buoy) — varchar(60)
- Aid availability category (category) — varchar(60)
Light (beacon-light)
- Buoy shape (shape) — varchar(60) — Foreign key → Generic Buoy.Buoy shape — NOT NULL
- Status (status) — varhcar(60) — Foreign key → Generic Buoy.Status
- Category of light (light) — integer
- Colour (colour) — integer
- Exhibition condition of light (exhibition) — varchar(60)
- Height (height) — varchar(60)
- Light characteristic (character) — varchar(60)
- Light visbility (visbility) — varchar(60)
- Navigtional system of marks (marks) — varchar(60)
- Multiplicity of lights (lights) — integer
- Object name in national language (national_language) — varchar(60)
- Object name (object_name) — varchar(60)
- Orientation (orientation) — varchar(60)
- Sector limit one (limit_one) — integer
- Sector limit two (limit_two) — integer
- Signal group (group) — varchar(60)
- Signal period (period) — timestamp
- Signal sequence (sequence) — integer
- Vertical accuracy (accuracy) — varchar(60)
- Vertical length (vertical_length) — integer
- Vertical datum (datum) — varchar(60)
- Type of light (type_light) — varchar(60)
- Type of battery (type_battery) — varchar(60)
- Value of geographical range (range) — varchar(60)
- Value of luminous range (value_range) — integer
- Remote monitoring system (system) — varchar(60)
- Remotely Monitored (monitored) — varchar(60)