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 CONSTRAINT users_id REFERENCES users(id),
	"paypoint_id" int CONSTRAINT paypoints_id REFERENCES paypoints(id),
	"amount" int,
	"description" varchar(255),
	"description" varchar(255),
	"ip" varchar(255),
	"status" int,
	"report_id" int CONSTRAINT payment_reports_id REFERENCES payment_reports(id),
	"ticket_id" int CONSTRAINT payment_tickets_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 CONSTRAINT paypoints_id REFERENCES paypoints(id),
	"user_id" int CONSTRAINT users_id REFERENCES users(id),
	"uniq_id" int,
	"firstName" varchar(255),
	"lastName" varchar(255),
	"amount" varchar(255)
);
CREATE TABLE "payment_reports" (
	"id" int,
	"paypoint_id" int,
	"user_id" int CONSTRAINT users_id REFERENCES users(id),
	"description" varchar(255),
	"payment_date" datetime CONSTRAINT payment_date REFERENCES payment(date)
);