Project C

Tables (5)

Customer_Info (고객정보Table)

  • cNum (고객정보) — Primary key — NOT NULL
  • mNum (업체정보) — Foreign key → M_Info.mNum — NOT NULL
  • cCompany (업체명)
  • cName (이름)
  • cLevel (직급)
  • cPhone (연락처)

M_Info (유지보수점검내용Table)

  • mNum (업체정보) — Primary key — NOT NULL
  • cNum (고객정보) — Foreign key → Customer_Info.cNum — NOT NULL
  • mCompany (업체명)
  • mLocation (업체위치)
  • mVendor (벤더업체)
  • mSystem (시스템명)
  • mFreepaid (유무상여부)
  • mBuildDate (구축일자)
  • mPaidConversion (유상전환시기)
  • mCheckform (점검형태)
  • mCheckPeriod (점검주기)
  • mCheckMethod (점검방식)
  • mCheckDate (점검일자)
  • mApplyProduct (적용제품)
  • mOtherProduct (외부제품)
  • mSysBuildManager (시스템구축담당자)
  • mExWalker (추가작업자)
  • mMainenanceManager (유지보수담당자)
  • mContent (유지보수처리내용및절차)
  • mWriteDate (입력날짜)

PaceSystem_Login (로그인Table)

  • pId (아이디) — Primary key — NOT NULL
  • pPw (비밀번호)
  • pName (이름)
  • pAuthority (권한)

Tax_Info (세금계산Table)

  • mNum (업체정보) — Foreign key → M_Info.mNum — NOT NULL
  • cNum (고객정보) — Foreign key → M_Info.cNum — NOT NULL
  • tContent (지원내용)
  • tDate (유지보수기간)
  • tCycle (발행주기)
  • tPublish (발행일)
  • tCash (청구금)
  • tNote (비고)

Tax_Record (세금납부내역Table)

  • mNum (업체정보) — Foreign key → Tax_Info.mNum — NOT NULL
  • cNum (고객정보) — Foreign key → Tax_Info.cNum — NOT NULL
  • trPrice (발행금액)
  • trDate (발행날짜)
  • trCheck (납부여부)