-
Notifications
You must be signed in to change notification settings - Fork 0
Schema details
Biswal2094 edited this page May 9, 2017
·
11 revisions
This section provides low level information of the application tables and their's relationship. In order to avoid any conflict with predefined keywords or similar tables we use table prefix as STR_. Hence all tables listed below will be prefixed with STR_ while creation and accessed accordingly.
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| CUSTOMERID | VARCHAR2 (20) | NO | PK |
| CUSTOMERNAME | VARCHAR2 (50) | YES | |
| GENDER | VARCHAR2(20) | YES | |
| AGE | VARCHAR2(20) | YES | |
| MOBILENUMBER | BIGINT | YES | |
| VARCHAR2(50) | YES | ||
| ADDRESS | VARCHAR2(200) | YES |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| PRODUCTID | VARCHAR2 (20) | NO | PK |
| PRODUCTNAME | VARCHAR2 (50) | YES | |
| CATEGORY | VARCHAR2(20) | YES | |
| DESCRIPTION | VARCHAR2(20) | YES | |
| SPECIFICATIONS | VARCHAR2(20) | YES | |
| QUANTITYINSTOCK | INTEGER | YES | |
| PRICE | DOUBLE | YES |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| USERNAME | VARCHAR2 (20) | NO | PK |
| PASSWORD | VARCHAR2 (50) | YES | |
| USERTYPE | VARCHAR2(20) | YES |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| ORDERID | VARCHAR2 (20) | NO | PK |
| CUSTOMERID | VARCHAR2 (50) | YES | FK |
| ORDERDATE | DATE | YES | |
| REQUIREDDATE | DATE | YES | |
| DISPATCHDATE | DATE | YES | |
| STATUS | VARCHAR2(20) | YES |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| ORDERDETAILID | VARCHAR2 (20) | NO | PK |
| ORDERID | VARCHAR2 (50) | YES | FK |
| PRODUCTID | VARCHAR2 (20) | YES | FK |
| UNITPRICE | DOUBLE | YES | |
| ORDERLINENUMBER | INTEGER | YES | |
| QUANTITY | INTEGER | YES | |
| DISCOUNT | DOUBLE | YES |