-
Notifications
You must be signed in to change notification settings - Fork 0
Tables
7702063479 edited this page May 16, 2017
·
5 revisions
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| USER_ID | VARCHAR2 (20) | NO | PK |
| PASSWORD | VARCHAR2 (20) | NO | |
| USER_TYPE | VARCHAR2 (20) | NO |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| USER_ID | VARCHAR2 (20) | NO | PK |
| USER_NAME | VARCHAR2 (50) | NO | |
| USER_AGE | NUMBER(3) | NO | |
| USER_GENDER | VARCHAR2 (10) | NO | |
| USER_ADDRESS | VARCHAR2 (100) | NO | |
| USER_PHONE | NUMBER(10) | NO | |
| USER_ID_TYPE | VARCHAR2 (20) | NO | |
| USER_ID_PROOF_NUMBER | VARCHAR2 (20) | NO | |
| USER_CHECKIN_DATE | DATE | NO | |
| USER_CHECKOUT_DATE | DATE | NO | |
| USER_ROOM_NUMBER | NUMBER (3) | NO | FK |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| ROOM_NUMBER | NUMBER (3) | NO | PK |
| ROOM_TYPE | VARCHAR2 (20) | NO | |
| ROOM_ISRESERVED | VARCHAR2 (20) | NO |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| USER_ID | VARCHAR2 (20) | NO | FK |
| ROOM_NUMBER | NUMBER (3) | NO | FK |
| PAY_MODE | VARCHAR2 (20) | NO | |
| TOTAL_AMOUNT | NUMBER (8,2) | NO |
| COLUMN NAME | DATA TYPE | NULLABLE | KEY |
|---|---|---|---|
| EMPLOYEE_ID | NUMBER (6) | NO | PK |
| EMPLOYEE_NAME | VARCHAR2 (20) | NO | |
| DOJ | DATE | NO | |
| MOBILE_NUMBER | VARCHAR2 (13) | NO | |
| EMPLOYEE_SALARY | NUMBER (8,2) | NO | |
| USER_ID | VARCHAR2 (20) | NO | FK |