27thTeam
Tables (9)
p_ai_response
- id — UUID — Primary key
- request_text — TEXT — NOT NULL
- response_text — TEXT
- created_at (Field) — TIMESTAMP
- created_by — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by (modified_by) — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
p_category
- id — UUID — Primary key
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(255)
p_location
- id — UUID — Primary key
- location_code — BIGINT — NOT NULL
- location — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by (modified_by) — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
p_menu_item
- id — UUID — Primary key — NOT NULL
- restaurant_id — UUID — Foreign key → p_restaurant.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INTEGER — NOT NULL
- is_available — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
p_order
- id — UUID — Primary key
- store_name — VARCHAR(255) — NOT NULL
- total_price — INTEGER — NOT NULL
- status — VARCHAR(255) — NOT NULL
- delivery_address — VARCHAR(255) — NOT NULL
- delivery_request — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- created_by (Field) — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by (Field2) — VARCHAR(255)
- deleted_at (Field3) — TIMESTAMP
- deleted_by (Field4) — VARCHAR(255)
p_order_item
- id — UUID — Primary key
- order_id — UUID — Foreign key → p_order.id
- menu_id — UUID — NOT NULL
- menu_quantity — INTEGER — NOT NULL
- menu_price — INTEGER — NOT NULL
- created_at — TIMESTAMP
- created_by (Field) — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by (Field2) — VARCHAR(255)
- deleted_at (Field3) — TIMESTAMP
- deleted_by (Field4) — VARCHAR(255)
p_restaurant
- id — UUID — Primary key
- category_id — UUID — Foreign key → p_category.id
- owner_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
- location — BIGINT — NOT NULL
- status — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(255)
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
- created_by — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)
p_user
- id — BIGINT — Primary key
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_at — TIMESTAMP
- updated_by (modified_by) — VARCHAR(255)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(255)