mysql table
来源:互联网 发布:淘宝达人在哪里找 编辑:程序博客网 时间:2024/06/07 10:02
级联删除foreign key (check_record_id) references sop_version_check_record(id) on delete cascade
CREATE DATABASE kenner DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use kenner;
/*==============================================================*/
/* Table: 产品表product */
/*==============================================================*/
create table product
(
product_id varchar(255) not null,
product_name varchar(255),
product_type varchar(255),
product_unit varchar(255),
product_spec varchar(255),
product_provision_id integer(11),
product_barcode varchar(255),
product_buy_price decimal(11,2),
product_total_price decimal(11,2),
product_period varchar(255),
product_price1 decimal(11,2),
product_price2 decimal(11,2),
product_price3 decimal(11,2),
product_num integer(11),
product_warn_min integer(11),
product_warn_max integer(11),
product_warn_refer integer(11),
product_status integer(11),
primary key (product_id),
KEY product_name_index USING BTREE (product_name)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 用户表user */
/*==============================================================*/
create table user
(
user_id varchar(255) not null,
user_name varchar(255),
user_department varchar(255),
user_tel varchar(255),
user_cellphone varchar(255),
user_address varchar(255),
user_email varchar(255),
user_role varchar(255),
user_birthday timestamp,
user_sex integer(11),
primary key (user_id)
) DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 供应商表provision */
/*==============================================================*/
create table provision
(
provision_id integer(11) not null auto_increment,
provision_name varchar(255),
provision_tel varchar(255),
provision_fax varchar(255),
provision_contact varchar(255),
provision_cellphone varchar(255),
provision_address varchar(255),
provision_remark text,
provision_email varchar(255),
provision_net_address varchar(255),
provision_status integer(11),
primary key (provision_id)
) DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 客户表customer */
/*==============================================================*/
create table customer
(
customer_id integer(11) not null auto_increment,
customer_name varchar(255),
customer_sex integer(11),
customer_cellphone varchar(255),
customer_address varchar(255),
customer_agreement_id varchar(255),
customer_email varchar(255),
customer_birthday timestamp,
customer_sns varchar(255),
primary key (customer_id)
) DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 应收账款表accounts_in */
/*==============================================================*/
create table accounts_in
(
accounts_in_id integer(11) not null auto_increment,
accounts_in_date timestamp,
accounts_in_sale_id integer(11),
accounts_in_suppose decimal(11,2),
accounts_in_real decimal(11,2),
accounts_in_user_id varchar(255),
accounts_in_admin_id varchar(255),
primary key (accounts_in_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 应付账款表accounts_out */
/*==============================================================*/
create table accounts_out
(
accounts_out_id integer(11) not null auto_increment,
accounts_out_date timestamp,
accounts_out_pay varchar(255),
accounts_out_type integer(11),
accounts_out_purchase_id integer(11),
accounts_out_suppose decimal(11,2),
accounts_out_real decimal(11,2),
accounts_out_user_id varchar(255),
accounts_out_admin_id varchar(255),
primary key (accounts_out_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 采购单表purchase */
/*==============================================================*/
create table purchase
(
purchase_id integer(11) not null auto_increment,
purchase_receive_time timestamp,
purchase_order_time timestamp,
purchase_pay_type integer(11),
purchase_tax integer(11),
purchase_user_id varchar(255),
purchase_provision_id integer(11),
purchase_product_name varchar(255),
purchase_product_num integer(11),
purchase_product_price decimal(11,2),
purchase_pay_suppose decimal(11,2),
purchase_arrival_time_suppose timestamp,
purchase_arrival_time_real timestamp,
purchase_storage_in_num integer(11),
purchase_storage_in_id integer(11),
purchase_express_id varchar(255),
purchase_express_price decimal(11,2),
purchase_express_price_per varchar(255),
primary key (purchase_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 入库单表storage_in */
/*==============================================================*/
create table storage_in
(
storage_in_id integer(11) not null auto_increment,
storage_in_purchase_id integer(11),
storage_in_time timestamp,
storage_in_provision_id integer(11),
storage_in_goods_allocation_id integer(11),
storage_in_product_name varchar(255),
storage_in_product_id varchar(255),
storage_in_product_unit varchar(255),
storage_in_num integer(11),
storage_in_price decimal(11,2),
storage_in_total_price decimal(11,2),
primary key (storage_in_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 出库单表(销售单表)sale */
/*==============================================================*/
create table sale
(
sale_id integer(11) not null auto_increment,
sale_product_id varchar(255),
sale_provision_id integer(11),
sale_goods_allocation_id integer(11),
sale_time timestamp,
sale_unit varchar(255),
sale_num integer(11),
sale_price decimal(11,2),
sale_total_price decimal(11,2),
primary key (sale_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 调拨单表requisition */
/*==============================================================*/
create table sop_version_define
(
requisition_id integer(11) not null auto_increment,
requisition_time timestamp,
requisition_product_id varchar(255),
requisition_product_name varchar(255),
requisition_goods_allocation_out integer(11),
requisition_goods_allocation_in integer(11),
requisition_user varchar(255),
requisition_num integer(11),
requisition_price decimal(11,2),
requisition_total_price decimal(11,2),
requisition_remark text,
requisition_status integer(11),
primary key (requisition_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 仓库表storage */
/*==============================================================*/
create table storage
(
storage_id integer(11) not null auto_increment,
storage_name varchar(255),
storage_address varchar(255),
storage_admin varchar(255),
storage_tel varchar(255),
storage_superior integer(11),
storage_status integer(11),
primary key (storage_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 库位表locator */
/*==============================================================*/
create table locator
(
locator_id integer(11) not null auto_increment,
locator_name varchar(255),
locator_storage_id integer(11),
locator_status integer(11),
primary key (locator_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 货位表goods_allocation */
/*==============================================================*/
create table goods_allocation
(
goods_allocation_id integer(11) not null auto_increment,
goods_allocation_name varchar(255),
goods_allocation_locator_id integer(11),
goods_allocation_status integer(11),
primary key (goods_allocation_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 质检表quality_checking */
/*==============================================================*/
create table quality_checking
(
quality_checking_id integer(11) not null auto_increment,
quality_checking_product_id varchar(255),
quality_checking_product_name varchar(255),
quality_checking_result integer(11),
quality_checking_remark text,
quality_checking_user_id varchar(255),
quality_checking_time timestamp,
primary key (quality_checking_id)
)DEFAULT CHARSET=utf8;
/*==============================================================*/
/* Table: 退换货表return_goods */
/*==============================================================*/
create table return_goods
(
return_goods_id integer(11) not null auto_increment,
return_goods_product_name varchar(255),
return_goods_product_id varchar(255),
return_goods_provision_id integer(11),
return_goods_agreement_id varchar(255),
return_goods_status integer(11),
return_goods_reason text,
primary key (return_goods_id)
)DEFAULT CHARSET=utf8;
0 0
- mysql table
- MYSQL TABLE TYPE
- ALTER TABLE语法--mysql
- MySQL - SHOW TABLE STATUS
- MySQL - ALTER TABLE语法
- mysql create table
- MySQL Create Table语句
- mysql create table
- mysql ALTER TABLE
- mysql优化Analyze Table
- mysql优化Analyze Table
- mysql alter table
- mysql temporary table
- MySQL show create table
- mysql 的table合并
- MYSQL TABLE TYPE
- mysql alter table总结
- MySQL的alter table
- 第三章 改进神经网络的学习方式(中下)
- 3.4趣味整数之黑洞数
- 【POJ】[1466]Girls and Boys
- extjs两行tbar的问题
- 直接插入排序
- mysql table
- Android Intent
- 一个tornado websocket 客户端例子
- 多个单选框的值传到后台
- MySQL备份之mysqlpump工具之--hex-blob参数
- Android 屏幕透明度控制
- C++几个常用类介绍第一篇
- 秒杀系统架构分析与实战
- H5在App中的应用