MySQL Create Table SQL
Table Structure: okayapi_box_invoice_item:/tablelist/okayapi_box_invoice_item.html
-- MySQL Table okayapi_box_invoice_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_invoice_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`invoice_id` bigint(20) NULL COMMENT '',
`type` varchar(100) NULL COMMENT '',
`rel_id` text NULL COMMENT '',
`task` varchar(100) NULL COMMENT '',
`status` varchar(100) NULL COMMENT '',
`title` varchar(255) NULL COMMENT '',
`period` varchar(10) NULL COMMENT '',
`quantity` bigint(20) NULL COMMENT '',
`unit` varchar(100) NULL COMMENT '',
`price` double(18,2) NULL COMMENT '',
`charged` tinyint(1) NULL DEFAULT '0' COMMENT '',
`taxed` tinyint(1) NULL DEFAULT '0' COMMENT '',
KEY `invoice_id` (`invoice_id`),
KEY `type` (`type`),
KEY `rel_id` (`rel_id`),
KEY `task` (`task`),
KEY `status` (`status`),
KEY `title` (`title`),
KEY `period` (`period`),
KEY `quantity` (`quantity`),
KEY `unit` (`unit`),
KEY `price` (`price`),
KEY `charged` (`charged`),
KEY `taxed` (`taxed`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-发票项目';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
invoice_id | bigint(20) | 是 | Normal Index | |||
type | varchar(100) | 是 | ||||
rel_id | text | 是 | ||||
task | varchar(100) | 是 | ||||
status | varchar(100) | 是 | ||||
title | varchar(255) | 是 | ||||
period | varchar(10) | 是 | ||||
quantity | bigint(20) | 是 | ||||
unit | varchar(100) | 是 | ||||
price | double(18,2) | 是 | ||||
charged | tinyint(1) | 0 | 是 | 0 | ||
taxed | tinyint(1) | 0 | 是 | 0 |