DDL ของ Star - Schema

mysql> use bank_imp;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_bank_imp |
+--------------------+
| account            |
| accounttype        |
| bank               |
| bondsman           |
| borrowbond         |
| customer           |
| detail             |
| detailtype         |
| employee           |
| promiseborrow      |
| promotion          |
+--------------------+
11 rows in set (0.00 sec)

mysql> CREATE  TABLE  Time (
    ->  TimeId  CHAR(3)  NOT NULL,
    ->  Year  YEAR(4)  NOT NULL,
    ->  Month  INT(2)  NOT NULL,
    ->  Day  INT(2)  NOT NULL,
    ->           CONSTRAINT Pk_TimeId PRIMARY KEY(TimeId)) comment = "สร้างตารางเวลา" ;
Query OK, 0 rows affected (0.05 sec)

mysql> CREATE TABLE  WarehouseBusI (
    ->  dwBusI_Code INT(3) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
    ->  WIProId  CHAR(3),
    ->  WICusId  CHAR(13),
    ->  WIAccTypeId CHAR(1),
    ->  WIAccId  CHAR(10),
    ->  WITimeId  CHAR(3),
    ->  WIAccUse  VARCHAR(50),
    ->  WIProUse  VARCHAR(50),  
    ->          CONSTRAINT Fk_WIPro  FOREIGN KEY(WIProId)
    ->    REFERENCES Promotion(ProId),
    ->         CONSTRAINT Fk_WICus  FOREIGN KEY(WICusId)
    ->    REFERENCES Customer(CusId),
    ->         CONSTRAINT Fk_WIAccT  FOREIGN KEY(WIAccTypeId)
    ->    REFERENCES AccountType(AccTypeId),
    ->          CONSTRAINT Fk_WIAcc  FOREIGN KEY(WIAccId)
    ->    REFERENCES Account(AccId),
    ->          CONSTRAINT Fk_WITime  FOREIGN KEY(WITimeId)
    ->    REFERENCES Time(TimeId)) comment = "รายงานที่ 1 รายงานประเภทบัญชีและโปรโมชัน";
Query OK, 0 rows affected (0.15 sec)

mysql> CREATE TABLE  WarehouseBusII (
    ->  dwBusII_Code INT(3) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
    ->  WIICusId  CHAR(13),
    ->  WIIAccTypeId CHAR(1),
    ->  WIIAccId  CHAR(10),
    ->  WIITimeId CHAR(3),
    ->  WIIDeTId  CHAR(1),
    ->  WIINumUse VARCHAR(50),
    ->          CONSTRAINT Fk_WIICus  FOREIGN KEY(WIICusId)
    ->    REFERENCES Customer(CusId),
    ->          CONSTRAINT Fk_WIIAccT  FOREIGN KEY(WIIAccTypeId)
    ->    REFERENCES AccountType(AccTypeId),
    ->          CONSTRAINT Fk_WIIAcc  FOREIGN KEY(WIIAccId)
    ->    REFERENCES Account(AccId),
    ->         CONSTRAINT Fk_WIITime  FOREIGN KEY(WIITimeId)
    ->    REFERENCES Time(TimeId),
    ->          CONSTRAINT Fk_WIIDeT  FOREIGN KEY(WIIDeTId)
    ->    REFERENCES DetailType(DeTId))  comment = "รายงานที่ 2 จำนวนการทำรายการต่างๆของแต่ละบัญชี"; 
Query OK, 0 rows affected (0.16 sec)

mysql> CREATE TABLE  WarehouseBusIII (
    ->  dwBusIII_Code INT(3) NOT NULL AUTO_INCREMENT,
    ->  WIIICusId CHAR(13),
    ->  WIIIAccId CHAR(10),
    ->  WIIITimeId CHAR(3),
    ->  WIIIDeTId CHAR(1),
    ->  WIIIBorrowId CHAR(8),
    ->  WIIICusUseBor VARCHAR(50),
    ->  WIIITotalBor VARCHAR(50),
    ->  WIIIReMoney VARCHAR(50),
    ->          CONSTRAINT    Pk_WIII  PRIMARY KEY(dwBusIII_Code),
    ->          CONSTRAINT Fk_WIIICus  FOREIGN KEY(WIIICusId)
    ->    REFERENCES Customer(CusId),
    ->          CONSTRAINT Fk_WIIIAcc  FOREIGN KEY(WIIIAccId)
    ->    REFERENCES Account(AccId),
    ->          CONSTRAINT Fk_WIIITime  FOREIGN KEY(WIIITimeId)
    ->    REFERENCES Time(TimeId),
    ->         CONSTRAINT Fk_WIIIDeT  FOREIGN KEY(WIIIDeTId)
    ->    REFERENCES DetailType(DeTId), 
    ->          CONSTRAINT Fk_WIIIBor  FOREIGN KEY(WIIIBorrowId)
    ->    REFERENCES PromiseBorrow(BorrowId)) comment = "รายงานที่ 3 รายงานเกี่ยวกับการกู้ยืมเงิน";
Query OK, 0 rows affected (0.16 sec)

mysql> show tables;
+--------------------+
| Tables_in_bank_imp |
+--------------------+
| account            |
| accounttype        |
| bank               |
| bondsman           |
| borrowbond         |
| customer           |
| detail             |
| detailtype         |
| employee           |
| promiseborrow      |
| promotion          |
| time               |
| warehousebusi      |
| warehousebusii     |
| warehousebusiii    |
+--------------------+
15 rows in set (0.00 sec)

mysql> notee