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)