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