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 (납부여부)