test
Tables (5)
assets
- id — BIGSERIAL
- network_id — BIGINT — NOT NULL
- serial_id — VARCHAR(64)
- label — TEXT
- level — INT
- shape — VARCHAR(32)
- image — VARCHAR(128)
- place — TEXT
network_type
- id — BIGSERIAL
- school_id — BIGINT — NOT NULL
- type — TEXT — NOT NULL
portmap_uploads
- id — BIGSERIAL
- school_id — BIGINT — NOT NULL
- school_code — VARCHAR(32)
- original_filename — TEXT
- stored_at — TIMESTAMPTZ — NOT NULL
- status — VARCHAR(32) — NOT NULL
ports
- id — BIGSERIAL
- network_id — BIGINT — NOT NULL
- from_port — VARCHAR(64)
- to_port — VARCHAR(64)
- label — VARCHAR(64)
school
- id — BIGSERIAL
- code — VARCHAR(32)
- update_from — INT
- school_name — TEXT