TABLE NAME

FIELD

RULE

CATEGORY TABLE

category_id

(auto generated)

should be 6 characters long

3-alphabets

3-digits

SUB_CATEGORY TLB

Subcategory_id

(auto generated)

should be 6 characters long

3-alphabets

3-digits

BRAND_TBL

brand_id          

should be 6 characters long

3-alphabets

3-digits

SALES MASTER_TBL

product_id

Payment_id

Expiration date

Auto generated

single digit

• if payment_id =1,2,3,4 then  cardno=16 digit
• If payment id = 5 then cardno =14 digit
• For all other pay_id cardno=NULL

mm/dd/yy, must be in future

Note: all these will be verified automatically by a credit card reader.

INVENTORY_TBL

serial_number  

Model number

Date_purchase

Date_sale

Supplier id

Must be provided

Must be provided

mm/dd/yy, can’t be future date

mm/dd/yy, must be present date

6 characters,

3 alphabets and 3 digits

STATUS_TBL

status_id

should be numeric value

DAMAGE_TBL

damage_id

Refurbished date

auto generated

can’t be future,mm/dd/yy

SUPPLIER_TBL

supllier_id

Phone number

lname: last name

fname: first name

<10 characters

Since the supplier can be from any country there are no restriction for phone number. But it must be provided to verify that the supplier is unique.

Required

required

PAYMENT_TBL

payment_id

must be a unique integer