表設計

#navi(contents-page-name): No such page: DB/Technolink

フィールド†

CREATE DATABASE TLDB
USE TLDB
CREATE TABLE BlockMaster (BlockCode INT PRIMARY KEY AUTO_INCREMENT, BlockName TEXT);
CREATE TABLE OfficeMaster (OfficeCode INT PRIMARY KEY AUTO_INCREMENT, OfficeName TEXT, BlockCode INT);
CREATE TABLE PersonnelMaster (PersonnelCode INT PRIMARY KEY AUTO_INCREMENT, PersonnelName TEXT, OfficeCode INT);
CREATE TABLE PrefectureMaster (PrefectureCode INT PRIMARY KEY, PrefectureName TEXT);
CREATE TABLE ProductMaster (ProductCode CHAR (32) PRIMARY KEY, ProductName TEXT);
CREATE TABLE KeywordMaster (KeywordCode INT PRIMARY KEY AUTO_INCREMENT, KeywordName TEXT);
CREATE TABLE DealerMaster (DealerCode INT PRIMARY KEY AUTO_INCREMENT, DealerName TEXT);
CREATE TABLE CustomerMaster (CustomerCode INT PRIMARY KEY AUTO_INCREMENT, KeywordCode INT,
             CustomerName TEXT, CustomerRuby TEXT, CustomerZipCode TEXT, PrefectureCode INT,
             CustomerAddress1 TEXT, CustomerAddress2 TEXT, CustomerPhone TEXT, CustomerFAX TEXT);
CREATE TABLE DealerFile (SerialCode CHAR(32), DealerCode INT, DealerPerson TEXT, DealerOrder INT);
CREATE TABLE SalesFile (SerialCode CHAR(32) PRIMARY KEY, ProductCode CHAR (32), PersonnelCode INT,
             CustomerCode INT, CustomerPerson TEXT, Price INT, ApplicationCode CHAR (32),
             ArrivalDate DATE, ShippingDate DATE);
↑

必要な表†

トップ   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS