실습

테이블 (8)

CD_MainUi (CopyOfCopyOfUntitled)

  • id (Key) — 기본 키 — NOT NULL
  • systemType (Field)
  • depthType (Field2)
  • previousDepth00~03 (Field3)
  • imgName (Field4)
  • contentName (Field5)
  • menuDescription (Field6)
  • contentDataName (file) — 외래 키 → CD_ccList.id — NOT NULL
  • startContentIndex (Key1) — 외래 키 → CD_ccList.id — NOT NULL
  • startContentIndex (Key2) — 외래 키 → CD_army.id — NOT NULL

CD_army (CopyOfCopyOfUntitled2)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • armyGroup (Field2)
  • armySize (Field3)
  • ccName (Field4)
  • ccDataIndex (Key2) — 외래 키 → CD_ccList.id — NOT NULL
  • ccLocation (Field6)

CD_ccList (CopyOfUntitled)

  • id (Key) — 기본 키 — NOT NULL
  • ccName (Field)
  • isDefault (Field2)
  • shelterName01~10 (Field3)
  • shelterIndex01~10 (Key2) — 외래 키 → CD_shelterList.id — NOT NULL

CD_functionGroup (CopyOfUntitled5)

  • id (Key) — 기본 키 — NOT NULL
  • shelterType (Field)
  • groupName (Field2)
  • functionName01~10 (Field3)
  • functionIndex01~10 (Key2) — 외래 키 → CD_functionList.id — NOT NULL

CD_functionList (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • functionType (Field2)
  • callResPref (Field3)

CD_shelterList (CopyOfUntitled2)

  • id (Key) — 기본 키 — NOT NULL
  • shlterName (Field)
  • inShelterRes (Field2)
  • outShelterRes (Field3)
  • inShelterLinkPref01~02 (Field4)
  • inShelterUnitGroup01~02 (Key2) — 외래 키 → CD_unitGroup.id — NOT NULL
  • outShelterLinkPref01~02 (Field6)
  • outShelterUnitGroup01~02 (Key3) — 외래 키 → CD_unitGroup.id — NOT NULL

CD_unitGroup (CopyOfUntitled3)

  • id (Key) — 기본 키 — NOT NULL
  • groupName (Field)
  • unitObj01~10 (Field2)
  • unitData01~10 (Key2) — 외래 키 → CD_unitList.id — NOT NULL

CD_unitList (CopyOfUntitled4)

  • id (Key) — 기본 키 — NOT NULL
  • shelterType (Field)
  • unitType (Field2)
  • unitName (Field3)
  • inRackImgName (Field4)
  • menuGroupIndex (Key3) — 외래 키 → CD_functionGroup.id — NOT NULL
  • rackUnit01~10 (Key2) — 외래 키 → CD_unitList.id — NOT NULL