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