SAJA_ERD
Tables (13)
BILLING_HISTORY
- USER_EMAIL (이메일) — VARCHAR2(30) — Foreign key → USER_INFO.U_EMAIL — NOT NULL
- PARTY_STUFF (물품이름) — VARCHAR2(30)
- PARTY_TIME (구매시간) — VARCHAR2(20)
- PARTY_PRICE (가격) — NUMBER
- PARTY_WHERE (위치) — VARCHAR2(10) — NOT NULL
- PARTY_CREATE (파티생성날짜) — VARCHAR2(20)
COMM
- Key — Primary key — NOT NULL
- U_EMAIL (이메일) — VARCHAR2(30) — Foreign key → USER_INFO.U_EMAIL — NOT NULL
- TITLE (제목) — VARCHAR2(100)
- CONTENT (게시글 내용) — VARCHAR2(255)
- SUBMIT_DATE (작성날짜) — VARCHAR2(20)
- COUNT (조회수) — NUMBER
- IP (IP주소) — VARCHAR2(20)
- LIKT_HIT (게시글 추천) — NUMBER
- REPLY_COUNT (댓글 수) — NUMBER
COMM_LIKE
- BOARD_ID (게시글ID) — VARCHAR2(30) — Primary key — NOT NULL
- U_EMAIL (이메일) — VARCHAR2(30) — Foreign key → USER_INFO.U_EMAIL — NOT NULL
- LIKE_CHECK (게시글 추천) — NUMBER
LOCATION_LARGE
- LOC_LARGE_CODE (지역 대분류 코드) — VHARCHAR2(5) — Primary key — NOT NULL
- LOC_LARGE_NAME (지역 이름) — VARCHAR2(20)
LOCATION_MIDDLE
- LOC_MIDDLE_CODE (지역 중분류 코드) — VHARCHAR2(5) — Primary key — NOT NULL
- LOC_LARGE_CODE (지역 대분류 코드) — VHARCHAR2(5) — Foreign key → LOCATION_LARGE.LOC_LARGE_CODE — NOT NULL
- LOC_MIDDLE_NAME (지역 중분류 이름) — VARCHAR2(30)
LOCATION_SMALL
- LOC_MIDDLE_CODE (지역 중분류 코드) — VHARCHAR2(5) — Foreign key → LOCATION_MIDDLE.LOC_LARGE_CODE — NOT NULL
- LOC_SMALL_CODE (지역 소분류 코드) — VARCHAR2(10)
- LOC_SMALL_NAME (지역 소분류 이름) — VARCHAR2(20)
MAIN_CATEGORIES
- MAIN_CAT_CODE (Key) — VHARCHAR2(5) — Primary key — NOT NULL
- MAIN_CAT_NAME (account_moneyd2) — VARCHAR2(20)
MIDDLE_CATEGORIES
- MAIN_CAT_CODE (Key) — VARCHAR2(5) — Foreign key → MAIN_CATEGORIES.MAIN_CAT_CODE — NOT NULL
- MIDDLE_CAT_CODE (Field2) — VARCHAR2(10)
- MIDDLE_CAT_NAME (Field) — VARCHAR2(20)
PARTY
- PARTY_ID (파티ID) — VARCHAR2(100) — Primary key — NOT NULL
- PARTY_TITLE (파티방 제목) — VARCHAR2(60)
- PARTY_STUFF (물품코드) — VARCHAR2(5)
- PARTY_TIME (구매날짜) — VARCHAR2(20) — NOT NULL
- PARTY_HOST (방 호스트) — VARCHAR2(30)
- PARTY_GUEST (방 게스트) — VARCHAR2(30)
- PARTY_WHERE (구매지역) — VARCHAR2(10)
- PARTY_CHAT (채팅) — VARCHAR2(10)
- PARTY_CONTENT (방 상세설명) — VARCHAR2(150)
- PARTY_DONE (구매완료여부) — NUMBER
- PARTY_CREATE (생성날짜) — VARCHAR2(20)
- PARTY_PRICE (구매가격) — NUMBER
- TAKE_HIT (추천 수) — NUMBER
PARTY_TAKE
- PARTY_ID (파티ID) — VARCHAR2(100) — Foreign key → PARTY.PARTY_ID — NOT NULL
- PARTY_TAKER (이메일) — VARCHAR2(30)
- PARTY_TAKE_CHECK (중복체크) — NUMBER
REVIEW
- REVIEW_ID (리뷰ID) — VARCHAR2(50) — Primary key — NOT NULL
- U_EMAIL (이메일) — varchar2(30) — Foreign key → USER_INFO.U_EMAIL — NOT NULL
- REVIEW_WRITER (리뷰작성자) — varchar2(20) — NOT NULL
- REVIEW_TARGET (리뷰대상자) — NUMBER
- REGDATE (리뷰등록일) — DATE
- REVIEW_TITLE (리뷰제목) — VARCHAR2(100)
- REVIEW_STATE (리뷰상태) — VARCHAR2(10)
- REVIEW_STUFF (물품코드) — VARCHAR2(5)
- REVIEW_CONTENT (리뷰내용) — VARCHAR2(255)
USER_INFO
- U_EMAIL (이메일) — varchar2(30) — Primary key — NOT NULL
- U_NAME (이름) — varchar2(20) — NOT NULL
- U_AGE (나이) — NUMBER
- U_GENDER (성별) — VARCHAR2(10)
- U_PW (비밀번호) — VARCHAR2(255)
- U_SALT (암호화문자열) — VARCHAR2(255)
USER_REPORT
- REPORT_ID (신고ID) — VARCHAR2(30) — Primary key — NOT NULL
- REPORTER_ID (신고자 이메일) — VARCHAR2(30) — Foreign key → USER_INFO.U_EMAIL — NOT NULL
- REPORTED_ID (피신고자 이메일) — VARCHAR2(30)
- REPORT_OBJECT (게시글분류) — VARCHAR2(20)
- REPORT_SORT (신고분류) — VARCHAR2(20)
- REPORT_REASON (신고사유) — VARCHAR2(100)
- REPORT_DATE (신고날짜) — DATE