department
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| department_name | varchar(255) | Yes | NULL | ชื่อหน่วยงาน |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 23 | A | No |
device
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| device_id | varchar(50) | Yes | NULL | |||
| serial_no | varchar(50) | Yes | NULL | |||
| device_brand | varchar(255) | Yes | NULL | |||
| device_model | varchar(255) | Yes | NULL | |||
| device_name | varchar(255) | Yes | NULL | ชื่อเครื่อง | ||
| memory | varchar(50) | Yes | NULL | |||
| cpu | varchar(100) | Yes | NULL | |||
| harddisk | varchar(100) | Yes | NULL | |||
| monitor | varchar(100) | Yes | NULL | |||
| mouse | varchar(255) | Yes | NULL | |||
| keyboard | varchar(255) | Yes | NULL | |||
| ex_drive | varchar(255) | Yes | NULL | |||
| hardware_other | text | Yes | NULL | |||
| other_detail | varchar(255) | Yes | NULL | |||
| device_ip | varchar(100) | Yes | NULL | |||
| date_use | date | Yes | NULL | |||
| date_expire | date | Yes | NULL | |||
| device_price | double(22,2) | Yes | NULL | |||
| device_docs | varchar(50) | Yes | NULL | |||
| vender | varchar(255) | Yes | NULL | |||
| warranty | varchar(255) | Yes | NULL | |||
| device_status | varchar(100) | No | enable | |||
| device_type_id | int(11) | No | ||||
| department_id | int(11) | No | ||||
| employee_id | int(11) | Yes | NULL | |||
| image | varchar(255) | Yes | NULL | |||
| mac | varchar(255) | Yes | NULL | |||
| software | varchar(1000) | Yes | NULL | |||
| software_sn | text | Yes | NULL | |||
| software_detail | varchar(1000) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 64 | A | No |
device_type
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| device_type | varchar(45) | Yes | NULL | หมวดหมู่อุปกรณ์ |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 11 | A | No |
employee
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| user_fullname | varchar(45) | Yes | NULL | |||
| user_position | varchar(100) | Yes | NULL | |||
| user_email | varchar(255) | Yes | NULL | |||
| user_phone | varchar(100) | Yes | NULL | |||
| department_id | int(11) | No | ||||
| username | varchar(255) | Yes | NULL | |||
| password_hash | varchar(255) | Yes | NULL | |||
| role | varchar(100) | No | ||||
| auth_key | varchar(255) | Yes | NULL | |||
| created_at | int(11) | No | ||||
| updated_at | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 40 | A | No |
job
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| job_number | varchar(100) | Yes | NULL | |||
| job_date | datetime | Yes | NULL | วันที่แจ้ง | ||
| job_detail | varchar(1000) | Yes | NULL | ปัญหา/อาการเสีย | ||
| job_start_date | datetime | Yes | NULL | วันที่ดำเนินการซ่อม | ||
| job_success_date | datetime | Yes | NULL | วันที่เสร็จ | ||
| job_how_to_fix | varchar(1000) | Yes | NULL | สาเหตุ/วิธีการซ่อม | ||
| price | int(11) | Yes | NULL | |||
| job_status | varchar(45) | Yes | NULL | สถานะการซ่อม | ||
| job_employee_id | int(11) | No | ||||
| job_type_id | int(11) | Yes | NULL | |||
| device_id | int(11) | Yes | NULL | |||
| user_id | int(11) | Yes | NULL | |||
| phone | varchar(100) | Yes | NULL | |||
| request_file | varchar(255) | Yes | NULL | |||
| success_file | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 12 | A | No |
job_type
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| job_type_name | varchar(45) | Yes | NULL | ประเภทงานซ่อม |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
migration
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| version | varchar(180) | No | ||||
| apply_time | int(11) | Yes | NULL |
software_detail
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| software_type_id | int(11) | No | ประเภทซอฟต์แวร์ | |||
| software_detail | varchar(255) | No | ชื่อซอฟต์แวร์ |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 9 | A | No |
software_type
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| software_type | varchar(100) | No | ประเภทซอฟต์แวร์ |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
system
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| line_token | varchar(255) | No | ||||
| login_required | int(11) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| fullname | varchar(255) | No | ||||
| username | varchar(255) | No | ||||
| position | varchar(255) | Yes | NULL | |||
| varchar(60) | Yes | NULL | ||||
| password_hash | varchar(60) | No | ||||
| auth_key | varchar(255) | Yes | NULL | |||
| created_at | int(11) | No | ||||
| updated_at | int(11) | No | ||||
| role | varchar(45) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |