DDL

CREATE TABLE EduDetail
                 (Seq                        NUMBER(3),
                  Institute                  VARCHAR(20),
                  Certificate                VARCHAR(20),
                  YearEnd                    NUMBER(4),
                  EmpNo                      CHAR(4),
                  CONSTRAINT  Pk_Seq        PRIMARY KEY(Seq)
                  CONSTRAINT  Fk_EmpNo   FOREIGN KEY(EmpNo)
                             REFERENCES           Employee(EmpNo));


CREATE  TABLE  History
                  (CitizenCardNo             VARCHAR(13),
                    BirthDate                VARCHAR(10),
                    Sex                      CHAR(1),
                    Salary                   NUMBER(8,2),
                    HouseNum                 CHAR(7),
                    Moo                      CHAR(2),
                    Road                     VARCHAR(20),
                    Region                   VARCHAR(20),
                    District                 VARCHAR(20),
                    Province                 VARCHAR(20),
                    PostCode                 CHAR(5),
                    EmpNo                       CHAR(4),
  --CONSTRAINT  Pk_CitizenCardNo  PRIMARY KEY(CitizenCardNo),
                    CONSTRAINT  Fk_EmpNo             FOREIGN KEY(EmpNo)
                          REFERENCES              Employee(EmpNo));


CREATE TABLE Employee
                ( EmpNo             CHAR(4),
                  ETitle            CHAR(6),
                  EFName            VARCHAR(20),
                  ELName            VARCHAR(20),
                  ETelNo            VARCHAR(10),
                  PosNo             NUMBER(3),
                  CONSTRAINT  Pk_EmpNo  PRIMARY KEY(EmpNo),
                  CONSTRAINT  Fk_EmpPos  FOREIGN KEY(PosNo)
                          REFERENCES              Position(PosNo));


CREATE  TABLE  Receipt
                  (RecNo                         CHAR(5),
                    RecDate                      DATE,
                    Total                        NUMBER(8,2),
                    Discount                     NUMBER(8,2),
                    Vat                          NUMBER(8,2),
                    GrandTotal                   NUMBER(8,2),
                    CusNo                        CHAR(4),
                     EmpNo                       CHAR(4),
                  CONSTRAINT  Pk_RecNo  PRIMARY KEY(RecNo),
                  CONSTRAINT  Fk_CusNo  FOREIGN KEY(CusNo)
                          REFERENCES              Customer(CusNo),
                  CONSTRAINT  Fk_EmpNo  FOREIGN KEY(EmpNo)
                          REFERENCES              Employee(EmpNo));

CREATE  TABLE  Customer
                  (CusNo                         CHAR(4),
                   CTitle                        CHAR(4),
                   CName                         VARCHAR(20),
                   Branch                        VARCHAR(20),
                   CTelNo                        VARCHAR(10),
                   HouseNum                      CHAR(7),
                   Moo                           CHAR(2),
                   Road                          VARCHAR(20),
                   Region                        VARCHAR(20),
                   District                      VARCHAR(20),
                   Province                      VARCHAR(20),
                   PostCode                      CHAR(5),
                   CONSTRAINT  Pk_CusNo  PRIMARY KEY(CusNo));

CREATE  TABLE RentContract
                  (ContractNo                     CHAR(4),
                    Std                           DATE,
                    End                           DATE,
                    ForkId                        CHAR(4),
                    CusNo                         CHAR(4),
                    CONSTRAINT  Pk_ContractNo  PRIMARY KEY(ContractNo),
                    CONSTRAINT  Fk_ForkId  FOREIGN KEY(ForkId)
                          REFERENCES              Forklift(ForkId),       
                    CONSTRAINT  Fk_CusNo  FOREIGN KEY(CusNo)
                          REFERENCES              Customer(CusNo));

CREATE  TABLE  Forklift
                  (ForkId                           CHAR(4),
                   Brand                            VARCHAR(10),
                   Generation                       CHAR(5),
                   PowerType                        VARCHAR(10),
                   RateCap                          NUMBER(6,2),
                   LiftHight                        NUMBER(6,2),
                   TypeId                           CHAR(5),
                    CONSTRAINT  Pk_ForkId  PRIMARY KEY(ForkId),
                    CONSTRAINT  Fk_TypeId  FOREIGN KEY(TypeId)
                          REFERENCES              ForkilftType(TypeId));

CREATE  TABLE  ForkliftType
     (TypeId                          CHAR(5),
       TypeName                       VARCHAR(10),
       CONSTRAINT  Pk_TypeId  PRIMARY  KEY(TypeId));

CREATE  TABLE  Product
        (ProNo                            CHAR(5),
          ProName                         VARCHAR(20),
           QOH                            NUMBER(30),
           PPU                            NUMBER(8,2),
           FPU                            NUMBER(8,2),
           DPU                            NUMBER(8,2),
          CONSTRAINT  Pk_ProNo  PRIMARY KEY(ProNo)); 

CREATE  TABLE  Sale
                  (SelSeq                         NUMBER(3),
                   Quantity                       NUMBER(2),
                   PPU                            NUMBER(8,2),
                   FPU                            NUMBER(8,2),
                   DPU                            NUMBER(8,2),
                   RecNo                          CHAR(5),
                   ProNo                          CHAR(5),
                   CONSTRAINT  Pk_SaleSeq  PRIMARY KEY(SelSeq),
                   CONSTRAINT  Fk_RecNo  FOREIGN KEY(RecNo)
                          REFERENCES              Receipt(RecNo),
                   CONSTRAINT  Fk_ProNo  FOREIGN KEY(ProNo));

CREATE  TABLE  Saller
                  (SaleNo                       CHAR(5),
                   STitle                       CHAR(4),
                   SName                        VARCHAR(20),
                   STelNo                       VARCHAR(10),
                   HouseNum                     CHAR(7),
                    Moo                         CHAR(2),
                    Road                        VARCHAR(20),
                    Region                      VARCHAR(20),
                    District                    VARCHAR(20),
                    Province                    VARCHAR(20),
                    PostCode                    CHAR(5),
                    CONSTRAINT  Pk_SaleNo  PRIMARY KEY(SaleNo));

CREATE  TABLE  TaxInvoice
                  (InvNo                        CHAR(6),
                   TaxDate                      DATE,
                   Total                        NUMBER(8,2),
                   Vat                          NUMBER(8,2),
                   GrandTotal                   NUMBER(8,2),
                   SaleNo                       CHAR(5),
                  CONSTRAINT  Pk_InvNo  PRIMARY KEY(InvNo),
                  CONSTRAINT  Fk_SaleNo  FOREIGN KEY(SaleNo)
                          REFERENCES              Saller(SaleNo));
CREATE  TABLE  Position
              (PosNo                NUMBER(3),
                PosName             VARCHAR(10),
                CONSTRAINT  Pk_PosNo  PRIMARY KEY(PosNo));

CREATE  TABLE  InvPro
                  (InvNo                         CHAR(6),
                   ProNo                         CHAR(5),
                   Quantity                      NUMBER(2),
                   CONSTRAINT  Pk_InvNo  PRIMARY KEY(InvNo),
                   CONSTRAINT  Pk_ProNo  PRIMARY KEY(ProNo));