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)