web ide

Tables (5)

Chats (Untitled3)

  • chat_id (PK) — INT(AUTO_INCREMENT) — Primary key — NOT NULL
  • user_id (FK) — INT(AUTO_INCREMENT) — Foreign key → Users.user_id — NOT NULL
  • message (Field2) — TEXT
  • create_at (Field) — TIMESTAMP

Compilation (Untitled4)

  • compiation_id (PK) — INT(AUTO_INCREMENT) — Primary key — NOT NULL
  • file_id (FK) — INT(AUTO_INCREMENT) — Foreign key → Files.file_id — NOT NULL
  • status (Field) — ENUM(SUCCESS, ERROR)
  • output (Field2) — TEXT
  • created_at (Field3) — TIMESTAMP

Files (Untitled2)

  • file_id (PK) — INT(AUTO_INCREMENT) — Primary key — NOT NULL
  • user_id (FK2) — INT(AUTO_INCREMENT) — Foreign key → Projects.user_id — NOT NULL
  • name (Field) — VARCHAR
  • content (Field2) — TEXT(source code)
  • create_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP

Projects (Untitled)

  • project_id (PK) — INT(AUTO_INCREMENT) — Primary key — NOT NULL
  • user_id (FK) — INT(AUTO_INCREMENT) — Foreign key → Users.user_id — NOT NULL
  • name (Field) — VARCHAR
  • details (Field2) — TEXT
  • created_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP

Users (Main)

  • user_id (PK) — INT(AUTO_INCREMENT) — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • email (Field3)