category
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(200) | No | ||||
| description | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
contact
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(50) | No | ||||
| lastname | varchar(50) | Yes | NULL | |||
| varchar(255) | No | |||||
| address | varchar(255) | Yes | NULL | |||
| phone | varchar(255) | Yes | NULL | |||
| image | varchar(255) | Yes | NULL | |||
| is_active | tinyint(1) | No | 1 | |||
| created_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
event
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(100) | No | ||||
| description | text | No | ||||
| date_at | varchar(50) | No | ||||
| time_at | varchar(50) | No | ||||
| created_at | datetime | No | ||||
| category_id | int(11) | Yes | NULL | category -> id | ||
| user_id | int(11) | No | user -> id | |||
| project_id | int(11) | Yes | NULL | project -> id |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| user_id | BTREE | No | No | user_id | 0 | A | No | |
| category_id | BTREE | No | No | category_id | 0 | A | Yes | |
| project_id | BTREE | No | No | project_id | 0 | A | Yes |
project
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(200) | No | ||||
| description | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| username | varchar(50) | No | ||||
| name | varchar(50) | No | ||||
| lastname | varchar(50) | No | ||||
| varchar(255) | No | |||||
| password | varchar(60) | No | ||||
| is_active | tinyint(1) | No | 1 | |||
| is_admin | tinyint(1) | No | 0 | |||
| created_at | datetime | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |