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