Database Schema - AtulDwivedi/shop-cart GitHub Wiki
Tables
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 SK_. Hence all tables listed below will be prefixed with SK_ while creation and accessed accordingly.
SK_CUSTOMER
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| CUSTOMER_ID | VARCHAR2 (20) | NO | PK |
| CUSTOMER_NAME | VARCHAR2 (50) | NO | |
| GENDER | VARCHAR2(20) | YES | |
| AGE | VARCHAR2(20) | YES | |
| MOBILE_NUMBER | VARCHAR2 (20) | YES | |
| VARCHAR2(50) | YES | ||
| ADDRESS | VARCHAR2(200) | YES |