pj2
Tables (8)
Announcments (announcements)
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- created_at — DATE
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
Documents (documents)
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- file_name (name) — VARCHAR(255)
- type — VARCHAR(255)
- file_size (size) — INT
- created_at — DATE
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
Members (members)
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
- role — VARCHAR(20)
- Field (approved) — BOOL
- joined_at — DATE
Organizations (organization)
- organization_id (id) — INT — Primary key — NOT NULL
- org_name (name) — VARHCAR(100)
- description — TEXT
- image — VARCHAR(255)
- code — VARCHAR(20)
- created_at — DATE
- user_id — INT — Foreign key → Users.user_id — NOT NULL
Posts (posts)
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — DATE
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
Schedules (schedules)
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- start_time — DATE
- end_time — DATE
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
Users (users)
- user_id (id) — INT — Primary key — NOT NULL
- username — VARCHAR(20)
- email — VARCHAR(255)
- password — VARCHAR(255)
- mobile — VARCHAR(20)
- image — VARCHAR(255)
- created_at — DATE
receipts
- id — INT — Primary key — NOT NULL
- type — VARCHAR(10)
- amount — INT
- category — VARCHAR(255)
- description — TEXT
- transaction_date (date) — DATE
- image — VARCHAR(255)
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL