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