Data Dictionary

Table 3.0 Data Dictionary of the System

Data Field Type Description
Officer Data Dictionary
Officer_ID int(11) Officer ID
Officer_Username varchar (55) Officer Username
Officer_Password varchar(55) Officer Username
Officer_Position varchar(55) Officer Position
Officer_Area varchar(77) Area Assign for Officer
Officer_Name varchar(55) Officer Name

 

Table 3.1 Lot Data Dictionary of the System

Data Field Type Description
Lot Data Dictionary
Lot_ID int(11) Lot ID
Lot_Date date (55) Date of Reservation
Lot_Address varchar(55) Location of Lot
Lot_Area varchar(55) Area of Lot
Lot_Amount medInt(11) Amount of Lot
Lot_Owner varchar(11) Owner of Lot
Lot_Block int(11) Block of Lot
Lot_Lot int(11) Space Lot
Lot_Phase int(11) Lot
Lot_Squaremeter

Latitude

Longtitude

int (11)

Float(10,5)

Float(10,5)

Square meter of Lot

Coordinates of Lot X axis

Coordinates of Lot Y axis


Table 3.2 Customer Withdrawal Data Dictionary of the System

Data Field Type Description
Customer Data Dictionary
CustomerW_ID int(11) Customer ID
CustomerW_FName varchar(55) Customer Full Name
CustomerW_Address varchar(55) Customer Address
CustomerW_Birthdate date(55) Customer Birthdate
CustomerW_Birthplace varchar(55) Customer Birthplace
CustomerW_Status varchar(55) Customer Status
CustomerW_TinNo. bigInt(20) Customer Tin Number
CustomerW_ContactNo. bigInt(11) Customer Contact Number
CustomerW_Income int(11) Customer Income
CustomerW_Occupation varchar(55) Customer Occupation
CustomerW_DateCancelled varchar(55) Customer Withdrawal

 

Table 3.3 Customer Data Dictionary of the System

Data Field Type Description
Customer Data Dictionary
Customer_ID int(11) Customer ID
Customer_FName varchar(55) Customer Full Name
Customer_Address varchar(55) Customer Address
Customer_Birthdate date (55) Customer Birthdate
Customer_Birthplace varchar(55) Customer Birthplace
Customer_Status varchar(55) Customer Status
Customer_TinNo. bigInt(20) Customer Tin Number
Customer_ContactNo. bigInt(11) Customer Contact Number
Customer_Income int(11) Customer Income
Customer_Occupation varchar(55) Customer Occupation
Customer_Balance int(11) Customer Balance

 

Table 3.4 Reservation Data Dictionary of the System

Data Field Type Description
Reservation Data Dictionary
Reservation_ID int(11) Reservation ID
Customer_ID int (11) Customer ID
Lot_ID int (11) Lot ID
Officer_Name varchar(55) Officer Name
Reservation_DYear int(11) Date of Year Reservation
Reservation_DMonth int(11) Day of month Reservation
Reservation_DDay int(11) Day of Reservation
Reservation_Area varchar(55) Lot Area
Reservation_Phase int(11) Lot Phase
Reservation_Lot int (11) Lot of Location
Reservation_Block int (11) Block of Location
Reservation_Squaremeter int (11) Lot Square meter
Reservation_Address varchar(55) Customer Address
Reservation_TotalAmount int (11) Customer Amount
Reservation_Buyer varchar(55) Customer Buyer

 

Table 3.5 SMS Data Dictionary of the System

Data Field Type Description
SMS Data Dictionary
SMS_ID int(11) SMS ID
SMS_Description varchar(180) SMS Reminders to the Customer
SMS_Date varchar(55) Date that send a message
SMS_Time varchar(55) Time that send a message
Customer_ContactNo bigInt(11) Customer Number
Customer_ID int(11) Customer ID

 

Table 3.6 Verification Data Dictionary of the System

Data Field Type Description
Data Field Type Description
Verification Data Dictionary
Veri_ID int(11) Verification ID
Veri_VerificationNumber varchar(11) Verification Code
Veri_CustName varchar(55) Customer Name
Veri_SendNum1 bigInt(20) Customer Number
Veri_DateSend varchar(55) Date Send by Officer
Veri_TimeSend varchar(55) Time Send by Officer

 

Table 3.7 Date Range Data Dictionary of the System

Data Field Type Description
Date Range Data Dictionary
DR_ID int(11) Duration ID
Lot_ID int(11) Lot ID
Cust_ID int(55) Customer ID
DR_SoldBy varchar(55) Customer Name
DR_FromDateYear varchar(55) Date of Reservation
DR_FromDateMonth varchar(55) Month of Reservation
DR_FromDateDay varchar(55) Day of Reservation
DR_LotArea varchar(55) Lot Area

 

Table 3.8 Image Data Dictionary of the System

Data Field Type Description
Image Data Dictionary
ID int(11) Image ID
Name varchar (77) Image Name
Image longblob Image

 


Table 3.9 Amortization Data Dictionary of the System

Data Field Type Description
Amortization Data Dictionary
A_ID int(11) Amortization_ID
A_NumPayment int(11) Number Payment
A_OBalance Double Old Balance
A_MPayment Double Monthly Payment
A_IPaid Double Interest Paid
A_PPaid Double Principal Paid
A_NBalance Double New Balance
Customer_ID Int(11) Customer_ID
A_MonthPay Int(55) Monthly Payment
A_DayPay Int(11) Current Date
A_YearPay Int(11) Yearly Payment
A_PaymentStatus Varchar(55) Payment Status

 

Table 3.10 Report Data Dictionary of the System

Data Field Type Description
Report Data Dictionary
VR_ID int(11) Verification ID
Customer_ID int(11) Customer ID
Lot_ID Varchar(111) Lot ID
Payment Int(55) Customer Payment
Num_Payment Int(11) Number of Payment
Due_Date Int(11) Due Date
Payment_Status Int(11) Payment Status
A_ID Int(11) Amortization ID

Questions