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