PROJECT
Referencing tables: attachment_link | project_agent | project_site | sample | site |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| name | varchar | ||
| name_en | varchar | ||
| number | varchar | ||
| project_type | int | project_type | |
| parent_project | int | project | |
| date_start | date | ||
| date_end | date | ||
| date_free | varchar | ||
| description | text | ||
| remarks | text | ||
| owner | int | agent | |
| is_private | tinyint | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment | |
| agents | int | agent |
