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