+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_box_service_domain:/tablelist/okayapi_box_service_domain.html


-- MySQL Table okayapi_box_service_domain
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_domain` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) NULL COMMENT '',
    `tld_registrar_id` bigint(20) NULL COMMENT '',
    `sld` varchar(255) NULL COMMENT '',
    `tld` varchar(100) NULL COMMENT '',
    `ns1` varchar(255) NULL COMMENT '',
    `ns2` varchar(255) NULL COMMENT '',
    `ns3` varchar(255) NULL COMMENT '',
    `ns4` varchar(255) NULL COMMENT '',
    `period` int(11) NULL COMMENT '',
    `privacy` int(11) NULL COMMENT '',
    `locked` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `transfer_code` varchar(255) NULL COMMENT '',
    `action` varchar(30) NULL COMMENT '',
    `contact_email` varchar(255) NULL COMMENT '',
    `contact_company` varchar(255) NULL COMMENT '',
    `contact_first_name` varchar(255) NULL COMMENT '',
    `contact_last_name` varchar(255) NULL COMMENT '',
    `contact_address1` varchar(255) NULL COMMENT '',
    `contact_address2` varchar(255) NULL COMMENT '',
    `contact_city` varchar(255) NULL COMMENT '',
    `contact_state` varchar(255) NULL COMMENT '',
    `contact_postcode` varchar(255) NULL COMMENT '',
    `contact_country` varchar(255) NULL COMMENT '',
    `contact_phone_cc` varchar(255) NULL COMMENT '',
    `contact_phone` varchar(255) NULL COMMENT '',
    `details` text NULL COMMENT '',
    `synced_at` datetime NULL COMMENT '',
    `registered_at` datetime NULL COMMENT '',
    `expires_at` datetime NULL COMMENT '',
    KEY `client_id` (`client_id`),
    KEY `tld_registrar_id` (`tld_registrar_id`),
    KEY `sld` (`sld`),
    KEY `tld` (`tld`),
    KEY `ns1` (`ns1`),
    KEY `ns2` (`ns2`),
    KEY `ns3` (`ns3`),
    KEY `ns4` (`ns4`),
    KEY `period` (`period`),
    KEY `privacy` (`privacy`),
    KEY `locked` (`locked`),
    KEY `transfer_code` (`transfer_code`),
    KEY `action` (`action`),
    KEY `contact_email` (`contact_email`),
    KEY `contact_company` (`contact_company`),
    KEY `contact_first_name` (`contact_first_name`),
    KEY `contact_last_name` (`contact_last_name`),
    KEY `contact_address1` (`contact_address1`),
    KEY `contact_address2` (`contact_address2`),
    KEY `contact_city` (`contact_city`),
    KEY `contact_state` (`contact_state`),
    KEY `contact_postcode` (`contact_postcode`),
    KEY `contact_country` (`contact_country`),
    KEY `contact_phone_cc` (`contact_phone_cc`),
    KEY `contact_phone` (`contact_phone`),
    KEY `details` (`details`),
    KEY `synced_at` (`synced_at`),
    KEY `registered_at` (`registered_at`),
    KEY `expires_at` (`expires_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-29 of 29 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
client_idbigint(20)Normal Index
tld_registrar_idbigint(20)Normal Index
sldvarchar(255)
tldvarchar(100)
ns1varchar(255)
ns2varchar(255)
ns3varchar(255)
ns4varchar(255)
periodint(11)
privacyint(11)
lockedtinyint(1)11
transfer_codevarchar(255)
actionvarchar(30)
contact_emailvarchar(255)
contact_companyvarchar(255)
contact_first_namevarchar(255)
contact_last_namevarchar(255)
contact_address1varchar(255)
contact_address2varchar(255)
contact_cityvarchar(255)
contact_statevarchar(255)
contact_postcodevarchar(255)
contact_countryvarchar(255)
contact_phone_ccvarchar(255)
contact_phonevarchar(255)
detailstext
synced_atdatetime
registered_atdatetime
expires_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 ↑