study1

Tables (4)

BOARD_TABLE (게시판)

  • BD_IDX (key) — NUMBER — Primary key — NOT NULL
  • BD_TITLE (Field) — VARCHAR
  • BD_CONTENT (Field2) — VARCHAR
  • BD_VIEW_CNT (Field3) — NUMBER
  • BD_IN_ID (Field4) — VARCHAR
  • BD_UP_ID (Field5) — VARCHAR
  • FILE_ID (Field6) — VARCHAR
  • BD_IN_DATE (Field7) — DATE
  • BD_UP_DATE (Field8) — DATE
  • BD_DEL_YN (Field9) — VARCHAR

FILE_DETAIL_TABLE (파일상세)

  • FILE_ID (Key) — VARCHAR — Primary key — NOT NULL
  • FILE_SN (Key2) — NUMBER — Primary key — NOT NULL
  • FILE_PATH (Field) — VARCHAR
  • FILE_PNAME (Field2) — VARCHAR
  • FILE_ONAME (Field3) — VARCHAR
  • FILE_EXT (Field4) — VARCHAR
  • FILE_SIZE (Field5) — VARCHAR

FILE_TABLE (파일)

  • FILE_ID (Key) — VARCHAR — Primary key — NOT NULL
  • INSERT_DATE (Field) — DATE
  • DEL_YN (Field2) — VARCHAR

USER_TABLE (사용자)

  • USER_ID (Key) — VARCHAR — Primary key — NOT NULL
  • USER_PW (Field) — VARCHAR
  • USER_NM (Field2) — VARCHAR
  • USER_MOBLIE (Field3) — VARCHAR
  • USER_EMAIL (Field4) — VARCHAR
  • USER_REG_DATE (Field5) — DATE
  • LOGIN_FAIL_CNT (Field6) — NUMBER
  • LAST_PW_CHNG_DATE (Field7) — DATE
  • USER_CHNG_DATE (Field8) — DATE
  • USER_ADDR (Field9) — VARCHAR
  • USER_ADDR_DETAIL (Field10) — VARCHAR
  • USER_ZIP_CODE (Field11) — VARCHAR
  • USER_QUIT_YN (Field12) — VARCHAR
  • USER_AUTH_CODE (Field13) — VARCHAR