SpacePj
Tables (13)
bank_info
- bank_code — VARCHAR2(10 BYTE) — Primary key — NOT NULL
- bank_name — VARCHAR2(50 BYTE) — NOT NULL
feedback
- fnum — NUMBER(10) — Primary key — NOT NULL
- rtnum — NUMBER(10) — Foreign key → reservation.rtnum
- snum — NUMBER(10) — Foreign key → space_info.snum
- userid — VARCHAR2(100 BYTE) — Foreign key → mem_info.userid
- r_code — NUMBER(8) — Foreign key → reason.r_code
- etc — VARCHAR2(1000 BYTE)
hashtag
- h_code — NUMBER(8) — Primary key — NOT NULL — 카테고리키
- h_name — VARCHAR2(30 BYTE) — NOT NULL — 해시태그명
heart_like
- hnum — NUMBER(10) — Primary key — NOT NULL
- snum — NUMBER(10) — Foreign key → space_info.snum
- userid — VARCHAR2(20 BYTE) — Foreign key → mem_info.userid
- hdate — DATE
mem_info
- userid — VARCHAR2(100 BYTE) — Primary key — NOT NULL — 회원아이디
- mname — VARCHAR2(20 BYTE) — NOT NULL — 이름
- nickname — VARCHAR2(30 BYTE) — 닉네임
- mpwd — VARCHAR2(150 BYTE) — NOT NULL
- hp — VARCHAR2(11 BYTE) — NOT NULL — 연락처
- birth — NUMBER(20)
- mdate — DATE
- status — NUMBER(5) — 회원상태
- point — NUMBER(10)
- mrank — NUMBER(10) — Foreign key → mem_rank.mrank
- account — NUMBER(20) — 계좌정보
- pointadd — NUMBER(10)
- bank_code — VARCHAR2(50 BYTE) — Foreign key → bank_info.bank_code
mem_rank
- mrank — NUMBER(10) — Primary key — NOT NULL
- rankpoint — NUMBER(10) — NOT NULL
payment
- paynum — NUMBER(20) — Primary key — NOT NULL
- imp_uid — VARCHAR2(50 BYTE) — NOT NULL
- merchant_uid — VARCHAR2(50 BYTE) — NOT NULL
- paydate — DATE
- amount — NUMBER(20) — NOT NULL
- status — VARCHAR2(10 BYTE) — NOT NULL
- refund_reason — VARCHAR2(200 BYTE)
- userid — VARCHAR2(50 BYTE) — Foreign key → mem_info.userid
- account — NUMBER(30) — Foreign key → mem_info.account
point
- paynum — NUMBER(10) — Primary key — NOT NULL
- userid — VARCHAR2(20 BYTE) — Foreign key → mem_info.userid
- pluspoint — NUMBER(20)
- paykind — VARCHAR2(100 BYTE)
- paydate — DATE
- paystatus — NUMBER(5)
qna_board
- qnum — NUMBER(8) — Primary key — NOT NULL — 문의글번호
- userid — VARCHAR2(20 BYTE) — Foreign key → mem_info.userid — 회원아이디
- snum — NUMBER(10) — Foreign key → space_info.snum
- qpwd — VARCHAR2(20 BYTE) — NOT NULL — 글비밀번호
- qtitle — VARCHAR2(200 BYTE) — NOT NULL — 글제목
- qcontent — VARCHAR2(2000 BYTE) — 글내용
- qdate — DATE — 작성일
- qgroup — NUMBER(8) — 글그룹
- qlevel — NUMBER(8) — 답변레벨
- qgorder — NUMBER(8) — 그룹순서
reason
- r_code — NUMBER(8) — Primary key — NOT NULL
- r_content — VARCHAR2(150 BYTE) — NOT NULL
reservation
- rtnum — NUMBER(10) — Primary key — NOT NULL
- snum — NUMBER(10) — Foreign key → space_info.snum
- userid — VARCHAR2(100 BYTE) — Foreign key → mem_info.userid
- rtstart — VARCHAR2(100 BYTE)
- rtend — VARCHAR2(100 BYTE)
- rtnumber — NUMBER(10)
- rtstatus — NUMBER(10)
- rtstartdate — VARCHAR2(20 BYTE)
- rdate — DATE
- totalprice — NUMBER
- Field
review
- review_num — NUMBER(8) — Primary key — NOT NULL
- userid — VARCHAR2(20 BYTE) — Foreign key → mem_info.userid
- snum — NUMBER(10) — Foreign key → space_info.snum
- rtitle — VARCHAR2(200 BYTE) — NOT NULL
- rcontent — VARCHAR2(2000 BYTE)
- review_date — DATE
- rscore — NUMBER(5)
- rimage1 — VARCHAR2(50 BYTE)
- rimage2 — VARCHAR2(50 BYTE)
- rgroup — NUMBER(8)
- rlevel — NUMBER(8)
- rgorder — NUMBER(8)
- rtnum — NUMBER(10) — Foreign key → reservation.rtnum
space_info
- snum — NUMBER(10) — Primary key — NOT NULL — 공간번호
- sname — VARCHAR2(50 BYTE) — NOT NULL — 공간명칭
- userid — VARCHAR2(20 BYTE) — Foreign key → mem_info.userid — 회원아이디
- minn — NUMBER(5) — 최소인원
- maxn — NUMBER(10) — 최다인원
- bcost — NUMBER(10) — 기본비용
- ecost — NUMBER(10) — 인원추가금
- spost — VARCHAR2(10 BYTE) — 우편번호
- saddr1 — VARCHAR2(100 BYTE) — 주소1
- saddr2 — VARCHAR2(100 BYTE) — 주소2
- slong — VARCHAR2(20 BYTE) — 지도경도값
- slat — VARCHAR2(20 BYTE) — 지도위도값
- sdate — DATE — 등록일
- h_code — NUMBER(8) — Foreign key → hashtag.h_code — 카테고리키
- simage1 — VARCHAR2(50 BYTE) — 이미지1
- simage2 — VARCHAR2(50 BYTE) — 이미지2
- simage3 — VARCHAR2(50 BYTE) — 이미지3
- simage4 — VARCHAR2(50 BYTE) — 이미지4
- scontents — VARCHAR2(1000 BYTE) — 공간설명
- srule — VARCHAR2(1000 BYTE)