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