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