+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_box_invoice:/tablelist/okayapi_box_invoice.html


-- MySQL Table okayapi_box_invoice
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_invoice` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) NULL COMMENT '',
    `serie` varchar(50) NULL COMMENT '',
    `nr` varchar(255) NULL COMMENT '',
    `hash` varchar(255) NULL COMMENT 'To access via public link',
    `currency` varchar(25) NULL COMMENT '',
    `currency_rate` decimal(13,6) NULL COMMENT '',
    `credit` double(18,2) NULL COMMENT '',
    `base_income` double(18,2) NULL COMMENT 'Income in default currency',
    `base_refund` double(18,2) NULL COMMENT 'Refund in default currency',
    `refund` double(18,2) NULL COMMENT '',
    `notes` text NULL COMMENT '',
    `text_1` text NULL COMMENT '',
    `text_2` text NULL COMMENT '',
    `status` varchar(50) NULL DEFAULT 'unpaid' COMMENT 'paid, unpaid',
    `seller_company` varchar(255) NULL COMMENT '',
    `seller_company_vat` varchar(255) NULL COMMENT '',
    `seller_company_number` varchar(255) NULL COMMENT '',
    `seller_address` varchar(255) NULL COMMENT '',
    `seller_phone` varchar(255) NULL COMMENT '',
    `seller_email` varchar(255) NULL COMMENT '',
    `buyer_first_name` varchar(255) NULL COMMENT '',
    `buyer_last_name` varchar(255) NULL COMMENT '',
    `buyer_company` varchar(255) NULL COMMENT '',
    `buyer_company_vat` varchar(255) NULL COMMENT '',
    `buyer_company_number` varchar(255) NULL COMMENT '',
    `buyer_address` varchar(255) NULL COMMENT '',
    `buyer_city` varchar(255) NULL COMMENT '',
    `buyer_state` varchar(255) NULL COMMENT '',
    `buyer_country` varchar(255) NULL COMMENT '',
    `buyer_zip` varchar(255) NULL COMMENT '',
    `buyer_phone` varchar(255) NULL COMMENT '',
    `buyer_phone_cc` varchar(255) NULL COMMENT '',
    `buyer_email` varchar(255) NULL COMMENT '',
    `gateway_id` int(11) NULL COMMENT '',
    `approved` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `taxname` varchar(255) NULL COMMENT '',
    `taxrate` varchar(35) NULL COMMENT '',
    `due_at` datetime NULL COMMENT '',
    `reminded_at` datetime NULL COMMENT '',
    `paid_at` datetime NULL COMMENT '',
    KEY `client_id` (`client_id`),
    KEY `serie` (`serie`),
    KEY `nr` (`nr`),
    KEY `hash` (`hash`),
    KEY `currency` (`currency`),
    KEY `currency_rate` (`currency_rate`),
    KEY `credit` (`credit`),
    KEY `base_income` (`base_income`),
    KEY `base_refund` (`base_refund`),
    KEY `refund` (`refund`),
    KEY `notes` (`notes`),
    KEY `text_1` (`text_1`),
    KEY `text_2` (`text_2`),
    KEY `status` (`status`),
    KEY `seller_company` (`seller_company`),
    KEY `seller_company_vat` (`seller_company_vat`),
    KEY `seller_company_number` (`seller_company_number`),
    KEY `seller_address` (`seller_address`),
    KEY `seller_phone` (`seller_phone`),
    KEY `seller_email` (`seller_email`),
    KEY `buyer_first_name` (`buyer_first_name`),
    KEY `buyer_last_name` (`buyer_last_name`),
    KEY `buyer_company` (`buyer_company`),
    KEY `buyer_company_vat` (`buyer_company_vat`),
    KEY `buyer_company_number` (`buyer_company_number`),
    KEY `buyer_address` (`buyer_address`),
    KEY `buyer_city` (`buyer_city`),
    KEY `buyer_state` (`buyer_state`),
    KEY `buyer_country` (`buyer_country`),
    KEY `buyer_zip` (`buyer_zip`),
    KEY `buyer_phone` (`buyer_phone`),
    KEY `buyer_phone_cc` (`buyer_phone_cc`),
    KEY `buyer_email` (`buyer_email`),
    KEY `gateway_id` (`gateway_id`),
    KEY `approved` (`approved`),
    KEY `taxname` (`taxname`),
    KEY `taxrate` (`taxrate`),
    KEY `due_at` (`due_at`),
    KEY `reminded_at` (`reminded_at`),
    KEY `paid_at` (`paid_at`),
    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-40 of 40 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
client_idbigint(20)Normal Index
serievarchar(50)
nrvarchar(255)
hashvarchar(255)To access via public linkUnique Index
currencyvarchar(25)
currency_ratedecimal(13,6)
creditdouble(18,2)
base_incomedouble(18,2)Income in default currency
base_refunddouble(18,2)Refund in default currency
refunddouble(18,2)
notestext
text_1text
text_2text
statusvarchar(50)unpaidpaid, unpaidunpaid
seller_companyvarchar(255)
seller_company_vatvarchar(255)
seller_company_numbervarchar(255)
seller_addressvarchar(255)
seller_phonevarchar(255)
seller_emailvarchar(255)
buyer_first_namevarchar(255)
buyer_last_namevarchar(255)
buyer_companyvarchar(255)
buyer_company_vatvarchar(255)
buyer_company_numbervarchar(255)
buyer_addressvarchar(255)
buyer_cityvarchar(255)
buyer_statevarchar(255)
buyer_countryvarchar(255)
buyer_zipvarchar(255)
buyer_phonevarchar(255)
buyer_phone_ccvarchar(255)
buyer_emailvarchar(255)
gateway_idint(11)
approvedtinyint(1)00
taxnamevarchar(255)
taxratevarchar(35)
due_atdatetime
reminded_atdatetime
paid_atdatetime

Guess You Like

MySQL Table Design okayapi_activity_admin_history

MySQL Table Design okayapi_activity_client_email

MySQL Table Design okayapi_activity_client_history

MySQL Table Design okayapi_activity_system

MySQL Table Design okayapi_box_admin

MySQL Table Design okayapi_box_admin_group

MySQL Table Design okayapi_box_cart

MySQL Table Design okayapi_box_cart_product

MySQL Table Design okayapi_box_client

MySQL Table Design okayapi_box_client_balance

MySQL Table Design okayapi_box_client_group

MySQL Table Design okayapi_box_client_order

MySQL Table Design okayapi_box_client_order_meta

MySQL Table Design okayapi_box_client_order_status

MySQL Table Design okayapi_box_client_password_reset

MySQL Table Design okayapi_box_currency

MySQL Table Design okayapi_box_email_template

MySQL Table Design okayapi_box_extension

MySQL Table Design okayapi_box_extension_meta

MySQL Table Design okayapi_box_form

TOP ↑