Skip to content

Entity Design

Subhrodip Mohanta edited this page Jun 7, 2022 · 5 revisions

Entity Strucuture

image

User Table

Column Name Column Definition
id Long - (PK)
username String (50) - (UNQ)
password String (50)
meal_prefernce Boolean (false = NON_VEG)
deleted Boolean
createdAt Long DATETIME(6)
creadtedBy String(30)
updatedAt Long DATETIME(6)
updatedBy String

Booking Table

Column Name Column Definition
id Long - (PK)
user Long - (FK of User[id])
mealPrefernce Boolean (false = NON_VEG)
dayOfBooking Date (ISO_FORMAT)
claimed Boolean (false = NOT)
createdAt Long DATETIME(6)
creadtedBy String(30)
updatedAt Long DATETIME(6)
updatedBy String
Clone this wiki locally