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