CREATE TABLE "users" (
	"id" int PRIMARY KEY,
	"username" varchar(255),
	"mail" varchar(255),
	"active" bool
);
CREATE TABLE "payments" (
	"id" int PRIMARY KEY,
	"user_id" int,
	"paypoint_id" int,
	"amount" int,
	"description" varchar(255),
	"description" varchar(255),
	"ip" varchar(255),
	"status" int,
	"report_id" int,
	"ticket_id" int,
	FOREIGN KEY("user_id") REFERENCES "users" ("id"),
	FOREIGN KEY("paypoint_id") REFERENCES "paypoints" ("id"),
	FOREIGN KEY("report_id") REFERENCES "payment_reports" ("id"),
	FOREIGN KEY("ticket_id") REFERENCES "payment_tickets" ("id")
);
CREATE TABLE "paypoints" (
	"id" int,
	"name" varchar(255),
	"account_name" varchar(255),
	"account_number" varchar(255),
	"account_iban" varchar(255),
	"description" varchar(255),
	"status" varchar(255)
);
CREATE TABLE "payment_tickets" (
	"id" int,
	"paypoint_id" int,
	"user_id" int,
	"uniq_id" int,
	"firstName" varchar(255),
	"lastName" varchar(255),
	"amount" varchar(255),
	FOREIGN KEY("paypoint_id") REFERENCES "paypoints" ("id"),
	FOREIGN KEY("user_id") REFERENCES "users" ("id")
);
CREATE TABLE "payment_reports" (
	"id" int,
	"paypoint_id" int,
	"user_id" int,
	"description" varchar(255),
	"payment_date" datetime,
	FOREIGN KEY("user_id") REFERENCES "users" ("id"),
	FOREIGN KEY("payment_date") REFERENCES "payment" ("date")
);