Data Dictionary
Table name: Login
Column Name Data Type Size Description Constraint Example
Unique identifier for
USER_NAME VARCHAR2 20 bytes PRIMARY KEY user123
user
PASSWORD VARCHAR2 20 bytes User account password NOT NULL pass@123
Table name: User_column
Column Name Data Type Size Description Constraint Example
Unique identifier for
USER_ID VARCHAR2 20 bytes PRIMARY KEY "USR12345"
the user
FOREIGN KEY
Username linked to
USER_NAME VARCHAR2 20 bytes REFERENCES "john_michael"
login
RY_LOGIN
User’s contact
CONTACT_NO NUMBER 20 bytes NOT NULL 9876543210
number
ADDRESS VARCHAR2 20 bytes User’s address NOT NULL "Street 123"
Vehicle number of
VEHICLE_NO VARCHAR2 20 bytes NOT NULL "MH12AB1234"
the user
SUBSCRIPTION_TYPE VARCHAR2 10 bytes Type of subscription NULLABLE "Premium"
First name of the
FIRSTNAME VARCHAR2 20 bytes NULLABLE "John"
user
Middle name of the
MIDDLENAME VARCHAR2 20 bytes NULLABLE "Michael"
user
LASTNAME VARCHAR2 20 bytes Last name of the user NULLABLE “Mathew”
Defines if the user is
ADMIN VARCHAR2 20 bytes NULLABLE "Yes"
an admin
Defines if the user is
REGULAR VARCHAR2 20 bytes NULLABLE "Yes"
a regular user
Table name: Parking lot
Column Name Data Type Size Description Constraint Example
Unique identifier
PARKINGLOT_ID VARCHAR2 20 bytes PRIMARY KEY "PL001"
for the parking lot
ID of the user
FOREIGN KEY REFERENCES
USER_ID VARCHAR2 20 bytes owning/reserving "USR123"
RY_USER_COLUMN(USER_ID)
parking
ID of the parking lot
OWNER_ID VARCHAR2 20 bytes NULLABLE "OWN567"
owner
Code assigned to
PARKINGLOT_CODE VARCHAR2 20 bytes NULLABLE "PARK-XYZ"
the parking lot
Total capacity of the
CAPACITY NUMBER 10 bytes NULLABLE 50
parking lot
Number of
AVAILABLESPACE NUMBER 10 bytes NULLABLE 20
available spaces
Date when the
STARTING_DATE DATE - parking lot became NULLABLE "2025-01-01"
active
Expiry date of the
ENDING_DATE DATE - NULLABLE "2025-12-31"
parking lot usage
Indicates if parking
OPEN VARCHAR2 20 bytes NULLABLE "Yes"
is open
Indicates if parking
UNDERGROUND VARCHAR2 20 bytes NULLABLE "No"
is underground
Indicates if parking
MULTILEVEL VARCHAR2 20 bytes NULLABLE "Yes"
has multiple levels
Table name: Parking owner
Column Name Data Type Size Description Constraint Example
Unique identifier for
OWNER_ID VARCHAR2 20 bytes PRIMARY KEY "OWN001"
the parking lot owner
FOREIGN KEY
ID of the associated REFERENCES
PARKINGLOT_ID VARCHAR2 20 bytes "PL123"
parking lot RY_PARKINGLOT
(PARKINGLOT_ID)
ADDRESS VARCHAR2 20 bytes Address of the owner NULLABLE "123 Street"
Name of the parking
OWNER_NAME VARCHAR2 20 bytes NULLABLE "John Michael"
lot owner
Password for the
OWNER_PASSWORD VARCHAR2 20 bytes NULLABLE "pass@123"
owner’s account
Contact number of the
CONTACT NUMBER 20 bytes NULLABLE 9876543210
owner
Date when the owner
START_DATE DATE - NULLABLE "2025-01-01"
registered
Expiry date of owner’s
END_DATE DATE - NULLABLE "2026-01-01"
account
Table name: Parking space
Column Name Data Type Size Description Constraint Example
PARKINGSPACE_ID VARCHAR2 20 bytes Unique identifier PRIMARY KEY "PS001"
Column Name Data Type Size Description Constraint Example
for the parking
space
FOREIGN KEY
ID of the
REFERENCES
PARKINGLOT_ID VARCHAR2 20 bytes associated parking "PL123"
RY_PARKINGLOT
lot
(PARKINGLOT_ID)
Date of last
LASTINSPECTION_DATE DATE - NULLABLE "2025-02-15"
inspection
Price of the
PRICE NUMBER 20 bytes NULLABLE 500
parking space
Status of the
parking space
STATUS VARCHAR2 20 bytes NULLABLE "Vacant"
(e.g., occupied,
vacant)
Space number in
SPACE_NO NUMBER 20 bytes NULLABLE 101
the parking lot
Indicates if the
NORMAL VARCHAR2 20 bytes parking space is NULLABLE "Yes"
normal
Indicates if the
parking space
EV VARCHAR2 20 bytes NULLABLE "No"
supports EV
charging
Table name: Notification
Column Name Data Type Size Description Constraint Example
TITLE VARCHAR2 20 bytes Notification title NOT NULL "Booking Confirmed"
Notification message
MESSAGE VARCHAR2 20 bytes NOT NULL "Your booking is set"
content
Time when the notification
SENDTIME VARCHAR2 20 bytes NOT NULL "2025-02-26 10:30AM"
was sent
Reference ID related to the
REFERENCE VARCHAR2 20 bytes NULLABLE "REF123456"
notification
Reservation details related
RESERVATION VARCHAR2 20 bytes NULLABLE "RSV56789"
to notification
Table name: Vehicle
Column Name Data Type Size Description Constraint Example
VEHICLE_NO VARCHAR2 20 bytes Unique identifier for vehicle PRIMARY KEY VH12345
USER_ID VARCHAR2 20 bytes User associated with vehicle FOREIGN KEY U1001
Name or model of the
VEHICLE_NAME VARCHAR2 20 bytes NOT NULL Honda Civic
vehicle
Type of fuel vehicle
FUEL_TYPE VARCHAR2 20 bytes NOT NULL Petrol
uses(petrol,desiel)
Category of vehicle (e.g.,
VEHICLE_TYPE VARCHAR2 20 bytes NOT NULL SUV
SUV, Sedan)
Table name: Payment
Column Name Data Type Size Description Constraint Example
Unique identifier for
PAYMENT_ID VARCHAR2 20 bytes PRIMARY KEY "PAY001"
the payment
Column Name Data Type Size Description Constraint Example
FOREIGN KEY
ID of the associated REFERENCES
PARKINGLOT_ID VARCHAR2 20 bytes "PL123"
parking lot RY_PARKINGLOT
(PARKINGLOT_ID)
Date of the payment
TRANSACTION_DATE DATE - NULLABLE "2025-02-26"
transaction
Mode of payment
PAYMENT_METHOD VARCHAR2 20 bytes NULLABLE "Credit Card"
(e.g., cash, card)
Status of the payment
PAYMENT_STATUS VARCHAR2 20 bytes NULLABLE "Success"
(e.g., success, failed)
Amount paid for the
AMOUNT NUMBER 20 bytes NULLABLE 100
transaction
One-time password for
OTP NUMBER 20 bytes NULLABLE 123456
verification
Table name: Feedback
Column Name Data Type Size Description Constraint Example
Unique identifier for
FEEDBACK_ID VARCHAR2 20 bytes PRIMARY KEY "FBK001"
feedback
Column Name Data Type Size Description Constraint Example
FOREIGN KEY
ID of the user REFERENCES
USER_ID VARCHAR2 20 bytes "USR123"
providing feedback RY_USER_COLUMN
(USER_ID)
Date when feedback
FEEDBACK_DATE DATE - NULLABLE "2025-02-26"
was submitted
PARKING_ID VARCHAR2 20 bytes ID of the parking area NULLABLE "PKG456"
Rating given by the
RATING NUMBER 20 bytes NULLABLE 5
user (1-5)
User comments or
COMMENTS VARCHAR2 20 bytes NULLABLE "Great service"
feedback
