web-ide-erd
Tables (5)
ChatMessage (RDS-3)
- id (Key) — bigint — Primary key — NOT NULL
- content (Field) — varchar(255)
- created_at (Field2) — timestamp
- userrepo_id (Key2) — bigint — Foreign key → UserRepo.userrepo_id — NOT NULL
FileMetaData (RDS)
- metadata (Key) — varchar(255) — Primary key — NOT NULL
- filepath (Field) — varchar(255)
- repo_id (Key2) — bigint — Foreign key → Repo.repo_id — NOT NULL
Repo (RDS-1)
- repo_id (Key) — bigint — Primary key — NOT NULL
- creator_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
- name (Field) — varchar(20)
- password (Field2) — varchar(255)
- language (Field3) — varchar(20)
- created_at (Field4) — timestamp
- modified_at (Field5) — timestamp
User (RDS-0)
- user_id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(20)
- nickname (Field2) — varchar(20)
- password (Field3) — varchar(255)
- created_at (Field4) — timestamp
- modified_at (Field5) — timstamp
UserRepo (RDS-2)
- userrepo_id (Key) — bigint — Primary key — NOT NULL
- repo_id (Key2) — bigint — Foreign key → Repo.repo_id — NOT NULL
- user_id (Key3) — bigint — Foreign key → User.user_id — NOT NULL