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