sports club data dictionary
TRANSCRIPT
Facilities
S.No Fields Name Data type
Description
1 F_code Long Facilities Code
2 F_name Text Facilities Name
3 Charges Single Charges Of Facilities
Member Facilities
S.No Fields Name
Data type
Description
1 M_code Long Member Code
2 F_code Text Name of Facilities
3 F_Type Text Tpe of Facilities either default or optional
Member TypeS.No Fields Name Data
TypeDescription
1 Mtype_code Integer Member Type Code
2 Mtype_name Text Member type Name
3 Mtype_fees Long Member Type Fess
4 Month Text How Many Month Validity Of particular
Members
S.No Fields Name Data Type Description
1 M_code Long Member code
2 M_name Text Member Name
3 Adders Text Members Address
4 join_date Date/time Joining Date
5 member_type Text Type of member
6 No_of_children_allow Byte How Many child allow
7 M_ship_exp_date Text Membership exp. date
Membership fees
S.No Fields Name Data Type Description
1 M_code Long Member code
2 Date_of_submission Date/time Date of fees submit
3 Mode_of_payment Text Payment Mode
4 Bank_name Text Bank name
5 Acno Long A/C No.
6 Detail Text Detail
7 Amount Single Amount
8 Fees_type Text Fess type either registration fees
or optional facilities charges
Parking
S.No Fields Name Data Type Description
1 M_code Long Member code
2 Vehicle No Text Vehicle Number
3 Entry date_time Date/time Entry date & time
4 Exit_date_time Date/time Exit date & Date
5 Status Boolean Status denote that particular member is present or not in
club
User Table
S.No Fields Name Data Type Description
1 User_name Text User name
2 User_password Text User password
Facilities
Data element F_code
Description Facilities Code
Type Long
Length 4
Data store Facilities
FacilitiesData element F_name
Description Facilities Name
Type Text
Length 50
Data store Facilities
Facilities
Data element Charges
Description Facilities Charges
Type Single
Length 4
Data store Facilities
Member Facilities
Data element M_code
Description Member Code
Type Long
Length 4
Data store Member Facilities
Member Facilities
Data element F_name
Description Facilities name
Type Text
Length 50
Data store Member facilities
Member Facilities
Data element F_type
Description Facilities type
Type Text
Length 50
Data store Member Facilities
Member Type
Data element Mtype_code
Description Member type code
Type Integer
Length 2
Data store Member Type
Member Type
Data element Mtype_name
Description Member type name
Type Text
Length 50
Data store Member Type
Member Type
Data element Mtype_fees
Description Member type fees
Type Long
Length 4
Data store Member Type
Member Type
Data element Month
Description How many month membership is valid
Type Text
Length 50
Data store Member Type
Members
Data element M_code
Description Member code
Type Long
Length 4
Data store Members
Members
Data element M_name
Description Member name
Type Text
Length 50
Data store Members
Members
Data element Address
Description Address of Member
Type Text
Length 50
Data store Members
Members
Data element Join date
Description Date of joining
Type Date/Time
Length 8
Data store Members
Members
Data element Member_type
Description Type of member
Type Text
Length 50
Data store Members
Members
Data element No_of_children allow
Description Number of child allow to a particular member in the club
Type Byte
Length 1
Data store Members
Members
Data element M_ship_exp_date
Description Membership expiry date
Type Text
Length 50
Data store Members
Membership_fees
Data element M_code
Description Member code
Type Long
Length 4
Data store Membership_fess
Membership_fees
Data element Date_of_submission
Description Date of fees submission
Type Date/Time
Length 8
Data store Membership_fees
Membership_fees
Data element Mode_of_payment
Description Payment mode
Type Text
Length 50
Data store Membership_fees
Membership_fees
Data element Bank_name
Description Bank name
Type Text
Length 50
Data store Membership_fees
Membership_fees
Data element Acno
Description A/C Number
Type Long
Length 4
Data store Membership_fees
Membership_fees
Data element Detail
Description Detail about payment
Type Text
Length 50
Data store Membership_fees
Membership_fees
Data element Amount
Description Amount paid by member
Type Single
Length 4
Data store Membership_fees
Membership_fees
Data element Fees_type
Description Fees type either registration or optional facilities charges
Type Text
Length 1
Data store Membership_fees
Parking
Data element M_code
Description Member Code
Type Long
Length 4
Data store Parking
Parking
Data element Vehicle_no
Description Vehicle number
Type Text
Length 50
Data store Parking
Parking
Data element Entry_date_time
Description Entry date & time
Type Date/Time
Length 8
Data store Parking
Parking
Data element Exit_date_time
Description Exit date & time
Type Date/Time
Length 8
Data store Parking
Parking
Data element status
Description Status denote that member is present or not in the club
Type Boolean
Length 1
Data store Parking
User Table
Data element User_name
Description Name of user
Type Text
Length 50
Data store User table
User Table
Data element User_password
Description User apssword
Type Text
Length 50
Data store User table