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