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)