TeamProject

Tables (6)

Document (CopyOfCopyOfUntitled)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key3) — int — Foreign key → User.id — NOT NULL
  • title (Field) — varchar(100)
  • content_blob (Field2) — bytea
  • version (Field3) — varchar(100)
  • prompt (Field4) — varchar(500)
  • storage_key (Field5) — varchar(255)
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

DraftAAL (CopyOfCopyOfCopyOfUntitled2)

  • id (Key) — int — Primary key — NOT NULL
  • document_id (Key2) — int — Foreign key → Document.id — NOT NULL
  • workplace_id (Field) — int
  • scenario (Field5)
  • disaster (Field2) — varchar(100)
  • aal (Field3) — varchar(100)
  • year (Field4) — int
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

GuideLine (CopyOfCopyOfCopyOfUntitled22)

  • id (Key) — int — Primary key — NOT NULL
  • tyoe (Field) — enum
  • content (Field2) — text
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

RiskResult (CopyOfCopyOfUntitled2)

  • id (Key) — int — Primary key — NOT NULL
  • workplace_id (Key2) — int — Foreign key → Workplace.id — NOT NULL
  • scenario (Field) — varchar(50)
  • disaster (Field2) — varchar(100)
  • aal (Field3) — varchar(100)
  • year (Field4) — int
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • email (Field2) — varchar(255)
  • password (Field3) — varchar(255)
  • affiliation (Field4) — varchar(255)
  • task (Field5) — varchar(255)
  • status (Field6) — boolean
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

Workplace (CopyOfUntitled)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key3) — int — Foreign key → User.id — NOT NULL
  • name (Field) — varchar(100)
  • address (Field2) — varchar(500)
  • tyoe (Field3) — varchar(100)
  • scale (Field4) — varchar(100)
  • latitude (Field5) — decimal(10, 6)
  • longitude (Field6) — decimal(10, 6)
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp