GSIM new

테이블 (6)

Files (tb_it_file)

  • ID (project_id) — varchar(255) — 외래 키 → 프로젝트와 모델.ID — NOT NULL
  • File Path (file_path) — varchar
  • File Classification (file_cals) — varchar
  • Memo (memo) — varchar

Geometry Type (tb_it_geom_type)

  • ID (geom_type_id) — int — 기본 키 — NOT NULL
  • Type Name (geom_type_nm) — varchar(40)

사용자 계정 (tb_it_user)

  • ID (user_id) — varchar(255) — 기본 키 — NOT NULL
  • Password (pw) — varchar(255)
  • Name (nm) — varchar(40)
  • Company (company) — varchar(40)
  • Phone Number (phone_no) — varchar(20)
  • E-mail (email) — varchar(255)
  • Role Level (level) — int
  • Memo (memo) — varchar
  • Regist Date (regist_dt) — timestamp
  • Last Login Date (last_dt) — timestamp
  • Deleted YN (is_deleted) — bool
  • Issue Count (issue_cnt) — int

스테이지 (tb_it_stage)

  • ID (stage_id) — int — 기본 키 — NOT NULL
  • Name (stage_nm) — varchar(255)

잡다한 테이블 (tb_it_issue)

  • ID (issue_id) — varchar(255) — 기본 키 — NOT NULL
  • User ID (user_id) — varchar(255) — 외래 키 → 사용자 계정.ID — NOT NULL
  • Project ID (project_id) — varchar(255) — 외래 키 → 프로젝트와 모델.ID — NOT NULL
  • Geometry Type ID (geom_type_id) — int — 외래 키 → Geometry Type.ID — NOT NULL
  • Create date (create_dt) — timestamp
  • Title (title) — varchar(40)
  • Content (content) — varchar
  • Deleted YN (is_deleted) — bool
  • Font Size (font_size) — int
  • Color (color) — varchar(20)
  • Properties (geom_prop) — varchar
  • Geometry (geom) — varchar

프로젝트와 모델 (tb_it_project)

  • ID (project_id) — varchar(255) — 기본 키 — NOT NULL
  • ID (stage_id) — int — 외래 키 → 스테이지.ID — NOT NULL
  • Name (nm) — varchar(40)
  • Create Date (create_dt) — timestamp
  • Parent ID (parent_id) — varchar(255) — NOT NULL
  • Depth (depth) — int
  • Location Point (geom) — varchar