test
Tables (9)
p_AI_response
- id — UUID
- request_text — TEXT — NOT NULL
- response_text — TEXT
- ) — created_at
- created_by — character
- deleted_at — timestamp(6)
- deleted_by — character
- modified_by — character
- updated_at — timestamp(6)
p_category
- id — UUID
- name — character — NOT NULL
- created_at — timestamp(6)
- created_by — character
- deleted_at — timestamp(6)
- deleted_by — character
- modified_by — character
- updated_at — timestamp(6)
p_location
- id — UUID
- location_code — BIGINT — NOT NULL
- location — VARCHAR(100) — NOT NULL
- created_at — timestamp(6)
- created_by — character
- deleted_at — timestamp(6)
- deleted_by — character
- modified_by — character
- updated_at — timestamp(6)
p_menu_item
- id — uui/d — Primary key — NOT NULL
- restaurant_id — uuid — NOT NULL
- name — character — NOT NULL
- price — integer — NOT NULL
- is_available — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- deleted_at — timestamp
- created_by — character — NOT NULL
- updated_by — character
- deleted_by — character
p_order
- id — UUID
- store_name — VARCHAR(100) — NOT NULL
- total_price — INT — NOT NULL
- status — VARCHAR(255) — NOT NULL
- delivery_address — VARCHAR(100) — NOT NULL
- delivery_request — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
p_order_item
- id — UUID
- menu_quantity — INT — NOT NULL
- menu_price — INT — NOT NULL
- order_id — UUID — NOT NULL
- menu_id — UUID — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
p_restaurant
- id — UUID
- name — VARCHAR(100) — NOT NULL
- category_id — BIGINT — NOT NULL
- location — BIGINT — NOT NULL
- owner_id — UUID — NOT NULL
- status — BOOLEAN — NOT NULL
- created_at — timestamp(6)
- created_by — character
- deleted_at — timestamp(6)
- deleted_by — character
- modified_by — character
- updated_at — timestamp(6)
p_review
- id — uuid — Primary key — NOT NULL
- order_id — uuid — NOT NULL
- content — text — NOT NULL
- rating — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- deleted_at — timestamp
- created_by — character — NOT NULL
- updated_by — character
- deleted_by — character
p_user
- id — bigint
- created_at — timestamp(6)
- created_by — varchar(255)
- deleted_at — timestamp(6)
- deleted_by — varchar(255)
- modified_by — varchar(255)
- updated_at — timestamp(6)
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — smallint — NOT NULL
- username — varchar(255) — NOT NULL