CampUs

Tables (17)

Biz (사업장기본정보)

  • bizKey (사업자고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • bizStatus (사업장상태관리) — CHAR(1)
  • bizAddress (사업자주소) — VARCHAR2(100)
  • bizAddressDetail (상세주소) — VARCHAR2(200)
  • bizSearchRegion (지역명) — VARCHAR2(5)
  • bizFileLocation (사업장File저장소) — VARCHAR2(50)
  • bizLayOutPicture (상품배치도) — VARCHAR2(50)
  • bizIntroduces (사업장소개글) — VARCHAR2(1000)
  • bizNotices (사업장공지사항) — VARCHAR2(1000)
  • bixRules (사업장운영정책) — VARCHAR2(1000)
  • bizAddProducts (추가상품정보) — VARCHAR2(1000)
  • bizCancelPolicies (Field) — VARCHAR2(1000)
  • bizManners (Field2) — VARCHAR2(1000)
  • serviceStartDate (서비스개시일) — Date
  • clickCount (조회수) — Integer
  • likeCount (찜카운트) — Integer

BizPictures (사업장홍보용 그림)

  • pictureKey (그림등록번호) — INTEGER — Primary key — NOT NULL
  • bizKey (사업자고유번호) — INTEGER — Foreign key → Biz.bizKey — NOT NULL
  • pictureName (그림파일명) — VARCHAR2(50)

BizWishLists (사용자찜목록)

  • wishKey (찜고유번호) — INTEGER — Primary key — NOT NULL
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • bizKey (사업자고유번호) — INTEGER — Foreign key → Biz.bizKey — NOT NULL

FreeBoard (자유게시판)

  • boardKey (게시판Key) — INTEGER — Primary key — NOT NULL
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • title (제목) — VARCHAR2(50)
  • content (내용) — VARCHAR2(100)
  • passwd (비밀번호) — VARCHAR2(50)
  • topFixed (상단고정) — VARCHAR2(1)
  • clickCount (조회건수) — INTEGER
  • likeCount (좋아요건수) — INTEGER
  • regDateTime (시스템등록일자) — DATE

FreeBoardComment (게시판댓글)

  • commentSeq (댓글 고유번호) — INTEGER — Primary key — NOT NULL
  • boardKey (게시판Key) — INTEGER — Foreign key → FreeBoard.boardKey — NOT NULL
  • content (댓글내용) — VARCHAR2(100)
  • regDateTime (등록일자) — DATE
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL

Payment (결제)

  • paymentKey (결제Key) — INTEGER — Primary key — NOT NULL
  • reserveKey (예약Key) — INTEGER — Foreign key → Reserve.reserveKey — NOT NULL
  • payDate (결제일시) — DATE
  • payKind (결제수단) — VARCHAR2(5)
  • payApproval (결제승인번호) — VARCHAR2(30)
  • payStatus (결제완료여부) — VARHCHAR2(1)
  • payBank (결제은행) — VARCHAR2(5)
  • payAmount (지불금액) — INTEGER

ProductReviews (상품사용후기)

  • reviewKey (사용후기Key) — INTEGER — Primary key — NOT NULL
  • reserveKey (예약Key) — INTEGER — Foreign key → Reserve.reserveKey — NOT NULL
  • reviewDate (작성일자) — DATE
  • oneCommentCode (한줄후기코드) — VARCHAR2(5) — Foreign key → category.categoryKey — NOT NULL
  • comment (사용후기) — VARCHAR2(100)
  • bestReview (베스트리뷰) — CHAR(1)
  • userKey (회원고유번호) — INTEGER
  • productKey (상품구분코드) — INTEGER

Products (상품)

  • productKey (상품구분코드) — INTEGER — Primary key — NOT NULL
  • bizKey (사업자고유번호) — INTEGER — Foreign key → Biz.bizKey — NOT NULL
  • productType (상품유형) — VARCHAR2(5) — Foreign key → category.categoryKey — NOT NULL
  • productStatus (상품상태관리) — CHAR(1)
  • productName (상품명) — VARCHAR2(50)
  • productDescription (상품설명) — VARCHAR2(100)
  • productPicName (상품사진) — VARCHAR2(50)
  • quantity (보유수량) — INTEGER
  • price (단가) — INTEGER
  • capacity (기준인원) — INTEGER
  • maxCapacity (최대인원) — INTEGER
  • addPricePerPerson (인원추가비용(인당)) — INTEGER

ResaleBoard (중고장터게시판)

  • resaleBoardKey (게시판Key) — INTEGER — Primary key — NOT NULL
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • buyOrSales (판매/구매구분) — CHAR(1)
  • title (제목) — VARCHAR2(50)
  • content (내용) — VARCHAR2(100)
  • attachFile (중고물품 사진) — VARCAHR2(50)
  • passwd (비밀번호) — VARCHAR2(50)
  • topFixed (상단고정) — VARCHAR2(1)
  • clickCount (조회건수) — INTEGER
  • likeCount (좋아요건수) — INTEGER
  • regDateTime (시스템등록일자) — DATE

ResaleBoardComment (중고장터게시판댓글)

  • commentSeq (댓글 고유번호) — INTEGER — Primary key — NOT NULL
  • resaleBoardKey (게시판Key2) — INTEGER — Foreign key → ResaleBoard.resaleBoardKey — NOT NULL
  • content (댓글내용) — VARCHAR2(100)
  • regDateTime (등록일자) — DATE
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL

Reserve (예약)

  • reserveKey (예약Key) — INTEGER — Primary key — NOT NULL
  • reserveNo (예약No) — VARCHAR2(30)
  • productKey (상품구분코드) — INTEGER — Foreign key → Products.productKey — NOT NULL
  • userKey (회원고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • reserveDate (예약일자) — Date
  • reserveStatus (예약상태) — VARCHAR2(10)
  • reserveStart (이용시작일) — Date
  • reserveEnd (이용종료일) — Date
  • reservePrice (단가) — INTEGER
  • reserveQty (신청수량) — INTEGER
  • remark (비고) — VARCHAR2(100)

ReserveInfo (예약상세정보)

  • reserveKey (예약Key) — INTEGER — Foreign key → Reserve.reserveKey — NOT NULL
  • reserverName (예약자이름) — VARCHAR2(30)
  • phoneNo (예약자전화번호) — VARCHAR2(20)
  • carNo (차량번호) — VARCHAR2(20)
  • addPerson (추가인원) — INTEGER
  • addPrice (추가단가) — INTEGER
  • request (요청사항) — VARCHAR2(50)
  • remark (비고) — VARCHAR2(100)

Users

  • userKey (회원고유번호) — INTEGER — Primary key — NOT NULL
  • userType (회원형태) — CHAR(1) — U,C,M
  • userID (회원ID) — VARCHAR2(30) — NOT NULL
  • Name (이름(사업자대표)) — VARCHAR2(30)
  • passWd (비밀번호) — VARCHAR2(100)
  • email (이메일) — VARCHAR2(50)
  • telNo (연락처) — VARCHAR2(20)
  • joinDate (가입일자) — Date
  • signOutDate (탈퇴일자) — Date
  • isBlackList (블랙리스트여부) — VARCHAR(1)
  • bizNo (사업자번호) — VARCHAR2(20)
  • bizName (사업자상호명) — VARCHAR2(100)
  • bizTelNo (사업장전화번호) — VARCHAR2(20)
  • remark (비고) — VARCHAR2(100)

bizHasProperties (사업장보유속성)

  • bizKey (사업자고유번호) — INTEGER — Foreign key → Biz.bizKey — NOT NULL
  • propertyKey (보유속성코드) — VARCHAR2(5) — Foreign key → category.categoryKey — NOT NULL

campUsNotices (공지사항)

  • noticeBoardKey (게시판Key) — INTEGER — Primary key — NOT NULL
  • userKey (등록자고유번호) — INTEGER — Foreign key → Users.userKey — NOT NULL
  • title (제목) — VARCHAR2(50)
  • content (내용) — VARCHAR2(100)
  • passwd (비밀번호) — VARCHAR2(50)
  • regDateTime (시스템등록일자) — DATE

category (코드테이블)

  • categoryKey (분류코드) — VARCHAR2(5) — Primary key — NOT NULL
  • categoryName (분류명) — VARCHAR2(50)
  • groupKey (분류코드2) — VARCHAR2(5) — Foreign key → category.categoryKey — NOT NULL
  • sortNum (정렬순서) — INTEGER
  • isUse (사용여부) — CHAR(1)
  • iconFileName (아이콘파일명) — VARCHAR2(50)

refund (결제취소)

  • refundKey (결제취소Key) — INTEGER — Primary key — NOT NULL
  • reserveKey (예약Key) — INTEGER — Foreign key → Reserve.reserveKey — NOT NULL
  • refundCancelCode (결제취소사유코드) — VARCHAR2(5) — Foreign key → category.categoryKey — NOT NULL
  • refundDate (취소일자) — DATE
  • refundBank (환불은행) — VARCHAR2(5)
  • refundDepositor (예금주) — VARCHAR2(30)
  • refundAccount (환불계좌번호) — VARCHAR2(30)
  • refundAmount (환불금액) — INTEGER
  • refundRestInfo (차감사유) — VARCHAR2(5)
  • refundRestpc (차감금액) — INTEGER
  • refundStatus (환불상태필드) — CHAR(1)
  • refundRemark (비고) — VARCHAR2(50)