dbdesign.sql

Table "bills" {
  "id" bigint [not null]
  "amount" double [not null]
  "discount" double [not null]
  "void" boolean [not null, default: false]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
  "payments_id" bigint
}

Table "items" {
  "id" bigint [not null]
  "name" "character varying" [not null]
  "price" double [not null]
  "description" "character varying"
  "image_url" "character varying"
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
}

Table "payments" {
  "id" bigint [not null]
  "name" "character varying" [not null]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
}

Table "purchase_details" {
  "id" bigint [not null]
  "price" double [not null]
  "quantity" bigint [not null]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
  "items_id" bigint
  "purchases_id" bigint
}

Table "purchases" {
  "id" bigint [not null]
  "customer_name" "character varying" [not null]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
}

Table "tables" {
  "id" bigint [not null]
  "name" "character varying" [not null]
  "capacity" bigint
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
  "tenants_id" bigint
}

Table "taxes" {
  "id" bigint [not null]
  "name" "character varying" [not null]
  "altname" "character varying" [not null]
  "type" "character varying" [not null]
  "value" "character varying" [not null]
  "multiplier" double [not null]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
}

Table "tenants" {
  "id" bigint [not null]
  "name" "character varying" [not null]
  "address" "character varying" [not null]
  "phone" "character varying" [not null]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
  "main_id" bigint
}

Table "users" {
  "id" bigint [not null]
  "fullname" "character varying" [not null]
  "username" "character varying" [not null]
  "password_hash" "character varying" [not null]
  "email" "character varying" [not null]
  "address" "character varying" [not null]
  "roles" smallint [not null, default: 0]
  "created_at" timestamp [not null]
  "updated_at" timestamp [not null]
}