DESTIN
Tables (9)
Notice board (notice_board)
- Board Index (idx) — INT — Primary key — NOT NULL
- Created user id (user_id) — INT — Foreign key → User account.User id — NOT NULL
- Name (name) — VARCHAR(255)
- Title (title) — VARCHAR(255)
- Description (description) — TEXT
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL
Project info (project_info)
- Project index (idx) — INT — Primary key — NOT NULL
- Created user id (user_id) — INT — Foreign key → User account.User id — NOT NULL
- Project ID (project_id) — INT
- Title (title) — VARCHAR(255)
- Description (description) — TEXT
- Work_step (work_step) — INT
- Created at (created_at) — DATETIME
- End at (end_at) — DATETIME — NOT NULL
Project_attachment (project_attachment)
- Project index (idx) — INT — Foreign key → Project_ing.Project index — NOT NULL
- Work_user_id (user_id) — INT — Foreign key → Project_ing.Work_user_id — NOT NULL
- mimetype — VARCHAR(255)
- File name (file_name) — VARCHAR(255)
- Original name (original_name) — VARCHAR(255)
- Work_step (work_step) — INT
- Destination (destination) — TEXT
- File Path (path) — TEXT — NOT NULL
- File size (size) — LONG
- description — TEXT
- Created at (created_at) — DATETIME
- Update at (Update_at) — DATETIME
Project_ing (project_ing)
- Project index (idx) — INT — Foreign key → Project info.Project index — NOT NULL
- Work_user_id (user_id) — INT — Foreign key → User account.User id — NOT NULL
- Project ID (project_id) — INT
- Title (title) — VARCHAR(255)
- Description (description) — TEXT
- Work_step (work_step) — INT
- Created at (created_at) — DATETIME
- Last activity (last_activity) — DATETIME — NOT NULL
- Error title (error_title) — String
- Error detail (error_detail) — TEXT
- Project end (project_end) — Boolean
User Log Type (User_log_type)
- User Log Type Id (idx) — INT — Primary key — NOT NULL
- name — CHAR(20)
- description — TEXT
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL
User account (user_account)
- User id (user_id) — INT — Primary key — NOT NULL
- User privilege id (user_privilege_id) — INT — Foreign key → User privilege.User privilege id — NOT NULL
- Company id (company_id) — INT
- Name (name) — VARCHAR(50)
- Email (email) — VARCHAR(255)
- Password (password) — String
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL
User log (user_log)
- User id (user_id) — INT — Foreign key → User account.User id — NOT NULL
- User Log Type Id (idx) — INT — Foreign key → User Log Type.User Log Type Id — NOT NULL
- User action (user_action) — VARCHAR(255)
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL
User privilege (user_privilege)
- User privilege id (user_privilege_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
- Description (description) — VARCHAR(255)
- Is Admin (is_admin) — Boolean
- Blocked (blocked) — Boolean
- Password (password) — String
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL
User session (user_session)
- id — INT — Primary key — NOT NULL
- User id (user_id) — INT — Foreign key → User account.User id — NOT NULL
- Ip address (ip_address) — VARCHAR(15)
- User agent (user_agent) — VARCHAR(50)
- Payload (payload) — VARCHAR(255)
- Last activity (last_activity) — DATETIME
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME — NOT NULL