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_MSG_ROOM (Untitled)

    TB_MSG_ROOM_USER (일단 보류)

      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