temp

Tables (10)

address

  • id — BIGINT — Primary key — NOT NULL
  • postal_code — VARCHAR(15)
  • address_line — VARCHAR(255) — NOT NULL
  • address_line_detail — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

food

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • food_category_major — VARCHAR(255)
  • food_category_minor — VARCHAR(255)
  • calories — VARCHAR(255)
  • protein — VARCHAR(255)
  • carbs — VARCHAR(255)
  • fat — VARCHAR(255)
  • sodium — VARCHAR(255)
  • sugars — VARCHAR(255)
  • fiber — VARCHAR(255)
  • saturated_fat — VARCHAR(255)
  • trans_fat — VARCHAR(255)
  • calcium — VARCHAR(255)
  • created_date — VARCHAR(255)
  • modified_date — VARCHAR(255)

order_approval_status

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

order_products

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • product_id — BIGINT — Foreign key → products.id — NOT NULL
  • quantity — INT — NOT NULL
  • price — BIGINT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • order_approval_status_id — BIGINT — Foreign key → order_approval_status.id — NOT NULL
  • address_id — BIGINT — Foreign key → address.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • order_date — TIMESTAMP — NOT NULL
  • ship_date — TIMESTAMP — NOT NULL
  • due_date — TIMESTAMP — NOT NULL
  • price — BIGINT — NOT NULL
  • comment — VARCHAR(255)
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

product_categories

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → product_categories.id
  • name — VARCHAR(100) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

products

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • product_category_id — BIGINT — Foreign key → product_categories.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • price — BIGINT — NOT NULL
  • stock — INT — NOT NULL
  • image_url — VARCHAR(50)
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • deleted_date — TIMESTAMP
  • food_id — BIGINT — Foreign key → food.id — NOT NULL

shopping_cart_products

  • id — BIGINT — Primary key — NOT NULL
  • quantity — INT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • product_id — BIGINT — Foreign key → products.id — NOT NULL

user_address

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • address_id — BIGINT — Foreign key → address.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30) — NOT NULL
  • role — VARCHAR(100) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • deleted_date — TIMESTAMP