- `id` int(11) NOT NULL AUTO_INCREMENT, # client id
- `group_id` int(11) NOT NULL, # group id
- `name` varchar(80) COLLATE utf8_bin NOT NULL, # client name
- `address` varchar(255) default NULL, # client address
- `tax` float(6,2) default '0.00', # applicable tax for this client
- `projects` text default NULL, # comma-separated list of project ids assigned to this client
- `status` tinyint(4) default 1, # client status
+ `id` int(11) NOT NULL AUTO_INCREMENT, # client id
+ `group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
+ `name` varchar(80) COLLATE utf8mb4_bin NOT NULL, # client name
+ `address` varchar(255) default NULL, # client address
+ `tax` float(6,2) default '0.00', # applicable tax for this client
+ `projects` text default NULL, # comma-separated list of project ids assigned to this client
+ `status` tinyint(4) default 1, # client status