qwer
테이블 (5)
게시글 (BOARD)
- BOARD_IDX (boardIdx) — int — 기본 키 — NOT NULL
- BOARD_TITLE (boardTitle)
- BOARD_CONTENT (boardContent)
- BOARD_WRITER_DATE (boardWriterDate)
- BOARD_PUBLIC_FL (Field)
- BOARD_DEL_YN (Field2)
- USER_IDX (userIdx) — int — 외래 키 → 회원.USER_IDX — NOT NULL
장소 (CAFE)
- BOARD_IDX (boardIdx) — int — 외래 키 → 게시글.BOARD_IDX — NOT NULL
- CAFE_NAME (cafeName) — varchar(255)
- CAFE_ADDRESS (cafeAddress) — varchar(255)
- CAFE_LATITUDES (cafeLatitudes) — varchar(255)
- CAFE_LONGITUDE (cafeLongitude) — varchar(255)
- Field
좋아요 (GOOD)
- BOARD_IDX (boardIdx2) — int — 외래 키 → 게시글.BOARD_IDX — NOT NULL
- STATUS (status) — varchar(5)
- Field
파일 (FILE)
- FILE_IDX (fileIdx) — int — 기본 키 — NOT NULL
- FILE_ORIGINAL_NAME (fileOriginalName) — varchar(255)
- FILE_CHANGED_NAME (fileChangedName) — varchar(255)
- FILE_PATH (filePath) — varchar(255)
회원 (MEMBER)
- USER_IDX (userIdx) — int — 기본 키 — NOT NULL
- USER_NAME (userName) — varchar(255)
- USER_ID (userId) — varchar(255)
- USER_PW (userPW) — varchar(255)
- SALT (salt) — varchar(255)
- USER_EMAIL (userEmail) — varchar(255)
- USER_PHONE (userPhone) — varchar(255)
- DEL_YN (delYN) — char
- FILE_IDX (fileIdx) — int