Tank_DB

Tables (8)

Country (country)

  • 나라 (Country) — varchar — Primary key
  • 이름 (name) — varchar
  • 식별여부 (aliance_t) — varchar — Foreign key → Friend_or_enemy.식별여부 — NOT NULL

Friend_or_enemy (countries)

  • 식별여부 (aliance_t) — varchar — Primary key — NOT NULL
  • 아군나라 (friend_country) — varchar

Tank (user_tank)

  • 전차_아이디 (Tank_id) — varchar — Primary key — NOT NULL
  • 전차이름 (Tank_name) — varchar
  • 이름 (Name) — varchar
  • 사용자아이디 (USER_id) — varchar — Foreign key → USER.사용자아이디
  • 나라 (Country) — varchar — Foreign key → Country.나라

Tank_SPAC (main_data)

  • 전차_아이디 (Tank_id) — varchar — Foreign key → Tank.전차_아이디 — NOT NULL
  • 전차이름 (tank_name) — varchar
  • 군비 (Armament) — varchar
  • 사용국가 (Country_user) — varchar
  • 제작국가 (Design_Country) — varchar
  • 전투장비 (Combet Equipment) — varchar
  • 탑승인원 (Crew) — int
  • 아머 (Armor) — varchar
  • 무게(kg) (weight(kg)) — float
  • 속도(km) (speed(km)) — float
  • 범위(km) (Range(km)) — float
  • 면적 (Dimensions) — varchar
  • Accessories — varchar
  • 길이(m) (Length(m)) — float
  • 너비(m) (width(m)) — float
  • 높이(m) (height(m)) — float

USER (user_id)

  • 사용자아이디 (USER_id) — varchar — Primary key
  • afflication (affllication) — time
  • 계급 (Field) — varchar
  • 식별코드 (random_code) — varchar(6)

classification_log (log)

  • 로그_아이디 (log_id) — varchar — Primary key — NOT NULL
  • 인식시간 (timestamp) — time
  • 프레임_당_전차식별도 (video_frame_uh) — varchar
  • confidence — varcahr
  • 전차식별자 (Detected_by) — varchar — Foreign key → log.전차식별자 — NOT NULL

log (log_csv)

  • 전차식별자 (Detected_by) — varchar — Primary key — NOT NULL
  • 기종 (Field) — varchar
  • 거리 (km) — float
  • 아군여부 (friend) — varchar

main (main_page)

  • 로그_아이디 (log_id) — varchar — Foreign key → classification_log.로그_아이디 — NOT NULL
  • 전차_아이디 (Tank_id) — varchar — Foreign key → Tank.전차_아이디 — NOT NULL