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