h2. Tables

Table should be in the plural¶

Table Modal should be in the singular and column name should be in the underscore(_) format¶

h3. 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

h3. 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

h3. Address Table

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

h3. 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

h3. Areas Table

id
name
is_active
created_at
updated_at

h3. Cities Table

id
name
is_active
created_at
updated_at