Aram Foundation Api

Tables¶

1. Table should be in the plural
2. Table Modal should be in the singular and column name should be in the underscore(_) format

Users Table¶

id
name
user_name
mobile
password
is_active
branch_id (branches table reference has one relation)
address_id (address table reference)
created_at
updated_at

Customers Table¶

id (uuid)
name
mobile
aadhar_no (define length exact adharno length + 5)
dob
age
gender
address_id (address table reference)
created_at
updated_at

Address Table¶

id
address
pin_code
area_id (area table reference)
city_id (city table reference)
created_at
updated_at

Bills Table¶

id
customer_id (optional customer table reference)
quantity
price
amount
user_id (user table reference)
branch_id (branch table reference)
created_at
updated_at

Areas Table¶

id
name
is_active
created_at
updated_at

Cities Table¶

id
name
is_active
created_at
updated_at