ㅁㄴㅇㄹ

테이블 (12)

board

  • BOARD_ID — NUMBER — 기본 키 — NOT NULL
  • SCHOOL_ID — NUMBER — NOT NULL
  • TYPE — NUMBER(1) — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • ANONYMOUS — NUMBER(1) — NOT NULL

comment

  • COMMENT_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(200) — NOT NULL
  • LIKE_COUNT — NUMBER(4) — NOT NULL
  • DATE — DATE — NOT NULL
  • RE_REF — NUMBER(10) — NOT NULL
  • RE_LEV — NUMBER(10) — NOT NULL
  • RE_SEQ — NUMBER(10) — NOT NULL
  • REPORT_COUNT — NUMBER(3) — NOT NULL
  • ANONYMOUS — NUMBER(1) — NOT NULL
  • POST_ID (POST_ID2) — NUMBER — 외래 키 → post.POST_ID — NOT NULL

comment_like

  • COMMENT_LIKE_ID — NUMBER — 기본 키 — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • COMMENT_ID — NUMBER — NOT NULL

comment_reply

  • COMMENT_REPLY_ID — NUMBER — 기본 키 — NOT NULL
  • COMMENT_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(200) — NOT NULL
  • LIKE_COUNT — NUMBER(4) — NOT NULL
  • DATE — DATE(30) — NOT NULL
  • REPORT_COUNT — NUMBER(3) — NOT NULL
  • ANONYMOUS — NUMBER(1) — NOT NULL

comment_reply_like

  • COMMENT_REPLY_LIKE_ID — NUMBER — 기본 키 — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • COMMENT_REPLY_ID — NUMBER — NOT NULL

photo

  • PHOTO_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER — NOT NULL
  • PATH — VARCHAR2(300) — NOT NULL

post

  • POST_ID — NUMBER — 기본 키 — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • BOARD_ID — NUMBER — NOT NULL
  • SUBJECT — VARCHAR2(200) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • FILE — VARCHAR2(200) — NOT NULL
  • LIKE_COUNT — NUMBER(10) — NOT NULL
  • DATE — DATE — NOT NULL
  • RE_REF — NUMBER(10) — NOT NULL
  • RE_LEV — NUMBER(10) — NOT NULL
  • RE_SEQ — NUMBER(10) — NOT NULL
  • SCRAP_COUNT — NUMBER(10) — NOT NULL
  • REPORT_COUNT — NUMBER(3) — NOT NULL
  • ANONYMOUS — NUMBER(1) — NOT NULL
  • SCRAP_ID — NUMBER(10) — 외래 키 → scrap.SCRAP_ID — NOT NULL
  • PHOTO_ID — NUMBER — 외래 키 → photo.PHOTO_ID — NOT NULL
  • BOARD_ID (BOARD_ID2) — NUMBER — 외래 키 → board.BOARD_ID — NOT NULL

post_like

  • LIKE_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • POST_ID (POST_ID2) — NUMBER — 외래 키 → post.POST_ID — NOT NULL

school

  • 유저 학교 (SCHOOL_ID) — NUMBER — 기본 키 — NOT NULL
  • SCHOOL_NAME — VARCHAR2(100) — NOT NULL
  • DOMAIN_EMAIL — VARCHAR2(100) — NOT NULL

scrap

  • SCRAP_ID — NUMBER(10) — 기본 키 — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • POST_ID — NUMBER — NOT NULL

user

  • 유저 고유번호 (USER_ID) — NUMBER — 기본 키 — NOT NULL
  • 유저 학교 (SCHOOL_ID) — NUMBER — 외래 키 → school.유저 학교 — NOT NULL
  • 유저 닉네임 (NICKNAME) — VARCHAR2(50) — NOT NULL
  • 유저 비밀번호 (PASSWORD) — VARCHAR2(100) — NOT NULL
  • 유저 이메일 (EMAIL) — VARCHAR2(100) — NOT NULL
  • 유저 학교 인증 여부 (SCHOOL_CHECK) — VARCHAR2(1) — NOT NULL
  • 유저 우편 번호 (ADDRESS_NUM) — VARCHAR2(10)
  • 유저 주소 (ADDRESS) — VARCHAR2(200)
  • PHONE_NUM — VARCHAR2(20) — NOT NULL
  • BOARD_ADMIN — NUMBER(1)
  • ACCOUNT_STATUS — NUMBER(1) — NOT NULL
  • ADMISSION_YEAR — NUMBER(4) — NOT NULL

권한 테이블 (Untitled)

  • 권한 여부 (PERMISSION) — NUMBER(1) — 기본 키
  • 게시판 권한 여부 (BOARD_P) — NUMBER(1)
  • 게시물 권한 여부 (POST_P) — NUMBER(1)
  • 댓글 권한 여부 (COMMENT_P) — NUMBER(1)