Customers Table:. assignment

Customers Table:
P/F FIELD NAME DATA TYPE FIELD
SIZE
NOTES
Name Varchar 20 This field holds full name of a
customer.
Contact int Contact column store every
contact number of a customer.
BirthDate date Birth Date field store every date
of birth of a customer.
CurrentAge decimal This field store current age of
the customer.
Days_Till_BirthDate int This column can generate how
many days are remaining for
birthdays
Date_joined date Date joined table defined the
join date of a customer.
Duration_as_member Decimal This column define the duration
time of a member.
30_Days_before_membership date This field indicate date before 30
days before of their membership.
Ranking the customers:
P/F FIELD NAME DATA TYPE FIELD SIZE NOTES

Name Varchar2 This field indicates the
full name of a customer
Amount spent to
date
decimal This field reflect the total
amount that a customer
spent.
Point int Points column indicate
the total point of a
customer.
No of referrals int Total number of referrals
are shown in this field.
Points int This field indicate the
point of customer. This
point is based on total
number of referrals.
Frequency of
appointments
int This field indicates the
total number of
appointment frequency
Points int This point are given
based on appointment
frequency
Number of
cancellation
int Total number of
cancellation can store
here
Points int Based on cancellation