ASFASFASFSA

Tables (10)

authority

  • USER_AUTH_ID — NUMBER — Primary key — NOT NULL
  • SCHOOL_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • DELETE_AUTH — NUMBER — NOT NULL

board

  • BOARD_ID — NUMBER — Primary key — NOT NULL
  • SCHOOL_ID — NUMBER — NOT NULL
  • USER_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 — Primary key — 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

comment_like

  • COMMENT_LIKE_ID — NUMBER — Primary key — NOT NULL
  • COMMENT_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL

photo

  • PHOTO_ID — NUMBER — Primary key — NOT NULL
  • POST_ID — NUMBER — NOT NULL
  • PATH — VARCHAR2(300) — NOT NULL

post

  • POST_ID — NUMBER — Primary key — NOT NULL
  • BOARD_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • SUBJECT — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • FILE — VARCHAR2(200)
  • DATE — DATE — NOT NULL
  • LIKE_COUNT — NUMBER(10) — NOT NULL
  • SCRAP_COUNT — NUMBER(10) — NOT NULL
  • REPORT_COUNT — NUMBER(3) — NOT NULL

post_like

  • LIKE_ID — NUMBER — Primary key — NOT NULL
  • POST_ID — NUMBER — NOT NULL
  • USER_ID — NUMBER — NOT NULL

school

  • SCHOOL_ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • DOMAIN — VARCHAR2(100) — NOT NULL

scrap

  • SCRAP_ID — NUMBER(10) — Primary key — NOT NULL
  • USER_ID — NUMBER — NOT NULL
  • POST_ID — NUMBER — NOT NULL

user

  • USER_ID — NUMBER — Primary key — NOT NULL
  • SCHOOL_ID — NUMBER — 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
  • ACCOUNT_STATUS — NUMBER(1) — NOT NULL
  • ADMISSION_YEAR — NUMBER(4) — NOT NULL