CREATE TABLE "users" ( "id" int, "email" varchar(255), "password" varchar(255) ); CREATE TABLE "admins" ( "id" int, "email" varchar(255), "password" varchar(255) ); CREATE TABLE "cards" ( "id" int, "card_number" varchar(255), FOREIGN KEY("card_number") REFERENCES "card" ("number") ); CREATE TABLE "statuses" ( "id" int, "user_id" int, "card_id" int, "online_count" int, "online_at" datetime, "offline_at" datetime, "status" bool, "value" int, FOREIGN KEY("user_id") REFERENCES "users" ("id"), FOREIGN KEY("card_id") REFERENCES "cards" ("id") );