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