DATABASE SCHEMA

Explore data model:

LOCALITY_SYNONYM

Contents: lokaliteedi nime sünonüümika

Referencing tables: None


Field Database column Data type Description Referenced table
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
locality locality int lokaliteedi unikaalne kood locality
pages pages varchar leheküljed
reference reference int viide sünonüümi kasutamisele reference
remarks remarks text lisainfo lokaliteedi sünonüümi kohta
synonym synonym varchar lokaliteedi nime sünonüüm
timestamp timestamp datetime ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record