PilLog
Tables (16)
BBS (게시판)
- BBS_CODE (Key) — Primary key — NOT NULL
- BBS_NAME (Field1) — VARCHAR
- BBS_SORT (Field2) — NUMBER
- FILE_CNT (Field3) — NUMbER
- LGN_READ_FORBIDDEN (Field4) — BOOLEAN
- ADMIN_WRITE_FORBIDDEN (filed5) — BOOLEAN
- BBS_SE (Field5) — NUMBER
TB_BANNER (배너)
- BANNER_ID (Key) — Primary key — NOT NULL
- CMN_FILE_ID (Key2) — Foreign key → TB_CMN_FILE.CMN_FILE_ID — NOT NULL
- AD_OWNER (Field) — VARCHAR
- DESCRIPTION (VARCHAR) — VARCHAR
TB_CMN_FILE (파일)
- CMN_FILE_ID (Key) — Primary key — NOT NULL
- PHYGICAL_FILE_NAME (Field) — VARCHAR
- LOGIC_FILE_NM (Field4) — VARCHAR
- FILE_EXTENSION (Field2) — VARCHAR
- FILE_PATH (Field3) — VARCHAR
- FILE_BYTE (Field33) — NUMBER
TB_COMMENT (댓글)
- COMMENT_ID (Key) — Primary key — NOT NULL
- POST_ID (Key2) — Foreign key → TB_POST.POST_ID — NOT NULL
- CONTENT (Field) — VARCHAR
- PARENT_ID (Field2) — NUMBER
- CREATE_DT (Field3) — TIMESTAMP
- CREATER (Field4) — NUMBER
- UPDATE_DT (Field5) — TIMESTAMP
- UPDATER (Field6) — NUMBER
TB_EMAIL_AUTH (이메일인증)
- EMAIL_AUTH_ID (Key) — Primary key — NOT NULL
- USER_ID (key) — Foreign key → TB_USER.USER_ID — NOT NULL
- CREAT_DT (Field2)
TB_GRADE (등급)
- GRADE_ID (Key) — Primary key — NOT NULL
- CMN_FILE_ID (Key2) — Foreign key → TB_CMN_FILE.CMN_FILE_ID — NOT NULL
- GRADE_RANK (Field) — NUMBER
TB_HREF (링크)
- HREF_ID (Key) — Primary key — NOT NULL
- URL (Field) — VARCHAR
- IS_BLANK (Field2) — NUMVER
TB_LIKE (좋아요)
- TARGET_TYPE (Key) — Primary key — NOT NULL
- TARGET_ID (Key3) — Primary key — NOT NULL
- LIKE_SE (Field) — NUMBER
- CREATE_DT (Field2)
- CREATER (Field3)
- UPDATE_DT (Field4)
TB_MENU (메뉴)
- MENU_ID (Key) — Primary key — NOT NULL
- TYPE_SE (Field)
- URL (Field2)
- PARENT_ID (Field3)
TB_MSG (쪽지)
- MSG_ID (Key) — NUMBER — Primary key — NOT NULL
- CONTENT (Field) — VARCHAR
- SND_ID (Field2) — NUMBER
- RCV_ID (Field3) — NUMBER
TB_POST (게시글)
- POST_ID (Key) — Primary key — NOT NULL
- BBS_ID (Key2) — Foreign key → BBS.BBS_CODE — NOT NULL
- TITLE (Field) — VARCAR
- CONTENT (Field2) — VARCHAR
- VIEW_CNT (Field7) — NUMBER
- ROCK_YN (Field8) — BOOLEAN
- CREATE_DT (Field3) — TIMESTAMP
- CREATER (Field4) — NUMBER
- UPDATE_DT (Field5) — TIMESTAMP
- UPDATER (Field6) — NUMBER
TB_POST_FILE (게시판 첨부파일)
- POST_FILE_ID (Key) — Primary key — NOT NULL
- POST_ID (Key2) — Foreign key → TB_POST.POST_ID — NOT NULL
- CMN_FILE_ID (Key3) — Foreign key → TB_CMN_FILE.CMN_FILE_ID — NOT NULL
TB_USER (회원)
- USER_ID (key) — Primary key — NOT NULL
- PROFILE_ID (Field6) — NUMBER
- ID (Fieldd) — VARCHAR
- PASSWD (Field) — VARCHAR
- NAME (Field2) — VARCHAR
- NICK_NAME (Field3) — VARCHAR
- EMAIL (Field4) — VARCHAR
- OAUTH_TYPE (Field5) — VARCHAR
TB_USER_GRADE (회원등급)
- USER_GRADE_ID (Key) — Primary key — NOT NULL
- GRADE_ID (Key2) — Foreign key → TB_GRADE.GRADE_ID — NOT NULL
- USER_ID (key) — Foreign key → TB_USER.USER_ID — NOT NULL
- CREATE_DT (Field) — TIMESTAMP