Soldier_basic_training

Tables (4)

Soldier_basic_training (장병기본훈련)

  • subject_key (과목_키) — int — Primary key — NOT NULL
  • subject_name (과목_이름) — varchar

level (단계)

  • level_key (처치단계_키) — varchar — Primary key — NOT NULL
  • subject_key (과목_키) — int — Foreign key → Soldier_basic_training.subject_key — NOT NULL
  • level_name (처치단계_이름) — varchar

process (술기)

  • process_key (술기_키) — int — Primary key — NOT NULL
  • level_key (처치단계_키) — varchar — Foreign key → level.level_key — NOT NULL
  • process_name (술기_이름) — varchar
  • details (상세내용) — text

soldier (군인)

  • army_number (군번) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar
  • military_rank (계급) — varchar
  • name (이름) — varchar