sports club data dictionary

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