oneTechHub

Tables (9)

admin (관리자)

  • admin_id (관리자아이디) — int — Primary key — NOT NULL
  • req_type (Field4) — varchar(255)
  • project_id (Field3) — int
  • tech_type (Field6) — varchar(255)
  • tech_name (Field5) — varchar(255)
  • fx_idx (프레임워크 아이디) — varchar(255)
  • is_approve (Field2) — varchar(255)

db (Untitled2)

  • db_id (Key) — int — Primary key — NOT NULL
  • db_name (Field) — varchar(255)

framework (CopyOfUntitled22)

  • framework_id (Key) — int — Primary key — NOT NULL
  • framework_name (Field) — varchar(255)
  • fw_idx (Field2) — varchar(255)

language (CopyOfUntitled23)

  • language_id (Key) — int — Primary key — NOT NULL
  • language_name (Field) — varchar(255)

project (프로젝트)

  • project_id (프로젝트아이디) — int — Primary key — NOT NULL
  • project_name (프로젝트명) — varchar(255)
  • last_commit (라스트커밋) — datetime(6)

project_db (Untitled)

  • project_db_id (Key) — int — Primary key — NOT NULL
  • project_id (프로젝트아이디) — int — Foreign key → project.project_id — NOT NULL
  • db_id (Key2) — int — Foreign key → db.db_id — NOT NULL

project_framework (CopyOfUntitled2)

  • project_db_id (Key) — int — Primary key — NOT NULL
  • project_id (프로젝트아이디) — int — Foreign key → project.project_id — NOT NULL
  • framework_id (Key2) — int — Foreign key → framework.framework_id — NOT NULL

project_language (CopyOfUntitled)

  • project_db_id (Key) — int — Primary key — NOT NULL
  • project_id (프로젝트아이디) — int — Foreign key → project.project_id — NOT NULL
  • language_id (Key2) — int — Foreign key → language.language_id — NOT NULL
  • ratio (Field3) — varchar(255)
  • codelines (Field4) — int

sboca_admin (Untitled3)

  • admin_id (Key) — int — Primary key — NOT NULL
  • emp_no (Field) — vvarchar(255)