Ramen Kuroda ERD
Tables (17)
Branch (Branches)
- ID (id) — int — Primary key — NOT NULL
- Name (name) — string
- Delivery Available (delivery_available) — boolean
- Pick Up Available (pickup_available) — boolean
- Service Charge (serviceCharge) — float
Branch Address (components_address_address)
- ID (id) — int — Primary key — NOT NULL
- Line1 (line1) — string
- Line2 (line2) — string
- City (city) — string
- State (state) — string
- Postal Code (postal) — string
- Country (country) — string
- Primary (primary) — boolean
- Geocode (geo) — coords
- Name (name) — string
- Field
- Branch (branch) — int — Foreign key → Branch.ID — NOT NULL
Contact Details (components_contact_details_contact_details)
- ID (id) — int — Primary key — NOT NULL
- Customer (customer) — int — Foreign key → Customer.ID — NOT NULL
Contactless Menu (components_pos_data_divergent_products)
- POS Data (pos_data_id) — int — Foreign key → POS Data.ID — NOT NULL
- Product (product) — int — Foreign key → Product.ID — NOT NULL
- Price (price) — float
- Active (isActive) — boolean
- Available (available) — boolean
Customer (customers)
- ID (id) — int — Primary key — NOT NULL
- First Name (firstName) — string
- Last Name (lastName) — string
- Middle Name (middleName) — string — NOT NULL
- Wallet Balance (walletBalance) — float
- Prime Member (primeMember) — boolean
- Available RK Points (available_rk_points) — float
- Annual RK Points (annual_rk_points) — float
- Total RK Points (total_rk_points) — float
- Tier (tier) — int — Foreign key → Tier.ID — NOT NULL
Customer Address (components_addresses_addresses)
- ID (id) — int — Primary key — NOT NULL
- Customer (customer) — int — Foreign key → Customer.ID — NOT NULL
- Line1 (line1) — string
- Line2 (line2) — string
- City (city) — string
- State (state) — string
- Postal Code (postal) — string
- Country (country) — string
- Primary (primary) — boolean
- Geocode (geo) — coords
- Name (name) — string
- Field
Email Address (email_addressess_email_addresses)
- ID (id) — int — Primary key — NOT NULL
- Contact Detail (contact_detail) — int — Foreign key → Contact Details.ID — NOT NULL
- Email (email) — string
- Field
LineItems (lineItems)
- ID (id) — int — Primary key — NOT NULL
- Order (order) — int — Foreign key → Order.ID — NOT NULL
- Product (product) — int — Foreign key → Product.ID — NOT NULL
- Quantity (quantity) — float
- Product Name (name) — string
- Product Description (description) — string
- Choice of Ramen (choiceOfRamen) — string
- Choice of Chahan (choiceOfChahan) — string
- Notes (notes) — string
- Price (price) — float
Mobile Number (mobile_numbers_mobile_numbers)
- ID (id) — int — Primary key — NOT NULL
- Contact Detail (contact_detail) — int — Foreign key → Contact Details.ID — NOT NULL
- Mobile Number (mobile) — string
- Field
Online Ordering Menu (components_menus_menu)
- Product (product) — int — Foreign key → Product.ID — NOT NULL
- Branch (branch) — int — Foreign key → Branch.ID — NOT NULL
- Price (price) — float
- Active (isActive) — boolean
- Available (available) — boolean
Order (orders)
- ID (id) — int — Primary key — NOT NULL
- Customer (customer) — int — Foreign key → Customer.ID — NOT NULL
- Branch (branch) — int — Foreign key → Branch.ID — NOT NULL
- Order Type (orderType) — enum — Allowed values: - contactless - pickup - delivery
- Status (status) — enum — Allowed values: - pending - preparing - prepared - delivering - delivered - completed - cancelled - void - failed
- Amount (amount) — float
- Order Notes (orderNotes) — string
- Person Count (personCount) — int
POS Data (components_pos_data_divergent_branches)
- ID (id) — int — Primary key — NOT NULL
- Branch (branch) — int — Foreign key → Branch.ID — NOT NULL
- Branch Code (branchCode) — string
- Field
Payment (payments)
- ID (id) — int — Primary key — NOT NULL
- Order (order) — int — Foreign key → Order.ID — NOT NULL
Phone Number (phone_numbers_phone_numbers)
- ID (id) — int — Primary key — NOT NULL
- Contact Detail (contact_detail) — int — Foreign key → Contact Details.ID — NOT NULL
- Phone Number (phone) — string
- Field
Product (products)
- ID (id) — int — Primary key — NOT NULL
- Name (name) — string
- Description (description) — string
- Contains (contains) — string — Text shown below product description which normally is used as warning for allergic contents of the food
- Featured (isFeatured) — boolean
- Product Category (product_category) — int — Foreign key → Product Category.ID — NOT NULL
- Sorting Key (sortingKey) — int
Product Category (product_category)
- ID (id) — int — Primary key — NOT NULL
- Field
Tier (tiers)
- ID (id) — int — Primary key — NOT NULL
- Tier Name (tiername) — string
- Minimum Points (minimumPoints) — int