Model Stationmeta

class StationmetaGlobalService (Base)

class toardb.stationmeta.models_global_services.StationmetaGlobalService(**kwargs)[source]

Bases: sqlalchemy.orm.decl_api._DynamicAttributesType, sqlalchemy.inspection.Inspectable[sqlalchemy.orm.mapper.Mapper[Any]]

Table “public.stationmeta_global_services”

Column

Type

Collation

Nullable

Default

variable_name

character varying(64)

not null

service_url

character varying(200)

not null

Indexes:

“stationmeta_global_services_service_url_key” UNIQUE CONSTRAINT, btree (service_url) “stationmeta_global_services_service_url_c8ee80c5_like” btree (service_url varchar_pattern_ops)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

variable_name
service_url
metadata: MetaData = MetaData()
registry: RegistryType = <sqlalchemy.orm.decl_api.registry object>

class StationmetaAnnotation (Base)

class toardb.stationmeta.models_annotation.StationmetaAnnotation(**kwargs)[source]

Bases: sqlalchemy.orm.decl_api._DynamicAttributesType, sqlalchemy.inspection.Inspectable[sqlalchemy.orm.mapper.Mapper[Any]]

Table “public.stationmeta_annotations”

Column

Type

Collation

Nullable

Default

id

integer

not null

nextval(‘stationmeta_annotations_id_seq’::regclass)

kind

integer

not null

0

text

text

not null

date_added

timestamp with time zone

not null

approved

boolean

not null

contributor_id

integer

not null

Indexes:

“stationmeta_annotations_pkey” PRIMARY KEY, btree (id) “stationmeta_annotations_contributor_id_a5009820” btree (contributor_id)

Check constraints:

“stationmeta_annotations_kind_check” CHECK (kind >= 0)

Foreign-key constraints:

“stationmeta_annotations_contributor_id_a5009820_fk_auth_user_id” FOREIGN KEY (contributor_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED “stationmeta_annotations_kind_fk_ak_vocabulary_enum_val” FOREIGN KEY (kind) REFERENCES ak_vocabulary(enum_val)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

id
kind
text
date_added
approved
contributor_id
station
metadata: MetaData = MetaData()
registry: RegistryType = <sqlalchemy.orm.decl_api.registry object>

class StationmetaRole (Base)

class toardb.stationmeta.models_role.StationmetaRole(**kwargs)[source]

Bases: sqlalchemy.orm.decl_api._DynamicAttributesType, sqlalchemy.inspection.Inspectable[sqlalchemy.orm.mapper.Mapper[Any]]

Table “public.stationmeta_roles”

Column

Type

Collation

Nullable

Default

id

integer

not null

nextval(‘stationmeta_roles_id_seq’::regclass)

role

integer

not null

status

integer

not null

contact_id

integer

not null

Indexes:

“stationmeta_roles_pkey” PRIMARY KEY, btree (id) “stationmeta_roles_contact_id_3bd9c160” btree (contact_id)

Check constraints:

“stationmeta_roles_role_check” CHECK (role >= 0) “stationmeta_roles_status_check” CHECK (status >= 0)

Foreign-key constraints:

“stationmeta_roles_contact_id_3bd9c160_fk_contacts_id” FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED “stationmeta_roles_role_fk_rc_vocabulary_enum_val” FOREIGN KEY (role) REFERENCES rc_vocabulary(enum_val) “stationmeta_roles_status_fk_rs_vocabulary_enum_val” FOREIGN KEY (status) REFERENCES rs_vocabulary(enum_val)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

id
role
status
contact_id
contact
station
metadata: MetaData = MetaData()
registry: RegistryType = <sqlalchemy.orm.decl_api.registry object>