test

Tables (5)

TABLE_BOARD

  • BOARD_NO — NUMBER — Primary key
  • USER_NAME (USER_NAME2) — VARCHAR2(50) — Foreign key → TABLE_USER.USER_NAME
  • AGE_RANGE — VARCHAR2(50)
  • BOARD_TITLE — VARCHAR2(200) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(2000) — NOT NULL
  • BOARD_DATE — DATE
  • LIKES — NUMBER

TABLE_FILES

  • FILE_NAME — VARCHAR2(4000) — Primary key
  • BOARD_NO (BOARD_NO2) — NUMBER — Foreign key → TABLE_BOARD.BOARD_NO
  • File_PATH — varchar2(4000)
  • ORIGINAL_FILE_NAME — VARCHAR2(4000) — NOT NULL

TABLE_REPLY

  • REPLY_NO — NUMBER — Primary key
  • BOARD_NO (BOARD_NO2) — NUMBER — Foreign key → TABLE_BOARD.BOARD_NO
  • USER_NO — NUMBER
  • REPLY_CONTENT — VARCHAR2(2000) — NOT NULL
  • REPLY_DATE — DATE

TABLE_USER

  • USER_NAME — VARCHAR2(50) — Primary key
  • USER_NO — NUMBER
  • USER_EMAIL — VARCHAR2(50) — NOT NULL
  • USER_PW — VARCHAR2(50) — NOT NULL
  • BIRTH_YEAR — VARCHAR2(50) — NOT NULL
  • AGE_RANGE — NUMBER
  • USER_STATUS — NUMBER

comments

  • cIdx — number
  • age_range — number
  • cmc — varchar2(4000)
  • cnt — number