客戶訂購登記系統(tǒng)課程設(shè)計(編輯修改稿)
2025-07-14 00:37 本頁面
【文章內(nèi)容簡介】 SE `customer_db`。 建立關(guān)系表建立賬單表：CREATE TABLE `t_bill` ( `bill_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 39。發(fā)票編號39。, `raiseddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 39。開票日期39。, `paydate` timestamp NOT NULL DEFAULT 39。00000000 00:00:0039。 COMMENT 39。付款日期39。, `o_id` int(11) NOT NULL COMMENT 39。訂單編號39。, `c_id` int(11) NOT NULL COMMENT 39。客戶編號39。, `pay_id` int(11) NOT NULL COMMENT 39。付款方式編號39。, PRIMARY KEY (`bill_id`), KEY `fk_bill_order` (`o_id`), KEY `fk_bill_customer` (`c_id`), KEY `fk_bill_pay` (`pay_id`), CONSTRAINT `fk_bill_customer` FOREIGN KEY (`c_id`) REFERENCES `t_customer` (`id`), CONSTRAINT `fk_bill_order` FOREIGN KEY (`o_id`) REFERENCES `t_order` (`id`), CONSTRAINT `fk_bill_pay` FOREIGN KEY (`pay_id`) REFERENCES `t_pay` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8。建立客戶表：CREATE TABLE `t_customer` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 39?？蛻艟幪?9。, `name` varchar(20) NOT NULL COMMENT 39。姓名39。, `zip` varchar(50) NOT NULL COMMENT 39。郵編39。, `tel` varchar(20) NOT NULL COMMENT 39。電話39。, `fax` varchar(20) NOT NULL COMMENT 39。傳真39。, `bankno` varchar(20) NOT NULL COMMENT 39。銀行帳號39。, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8。建立職工表：CREATE TABLE `t_employee` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 39。職工編號39。, `name` varchar(20) NOT NULL COMMENT 39。姓名39。, `sex` varchar(20) NOT NULL COMMENT 39。性別39。, `dob` date NOT NULL COMMENT 39。出生日期39。, `address` varchar(50) NOT NULL COMMENT 39。地址39。, `worktel` varchar(20) NOT NULL COMMENT 39。辦公電話39。, `hometel` varchar(20) NOT NULL COMMENT 39。住宅電話39。, `` varchar(20) NOT NULL COMMENT 39。郵箱39。, `position` varchar(20) NOT NULL COMMENT 39。職位39。, `title` varchar(20) NOT NULL COMMENT 39。職稱39。, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8。建立訂單表：CREATE TABLE `t_order` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 39。訂單編號39。, `p_id` int(11) NOT NULL COMMENT 39?？蛻艟幪柵?9。, `order_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 39。訂貨日期39。, `jiao_date` timestamp NOT NULL DEFAULT 39。00000
試題試卷相關(guān)推薦
鄂ICP備17016276號-1