LuckyYeonJPA

Tables (7)

BoardLike (게시판 좋아요)

  • board_no (Field) — Primary key
  • id (Field2) — Primary key
  • likedate (Field3)

BoardUploadFile (소슐랭가이드 게시판 업로드파일)

  • board_no (Field)
  • id (Field4)
  • filelink (Field2)
  • uploaddate (Field3)

GuideBoard (소슐랭가이드 게시판)

  • board_no (Key) — Primary key — NOT NULL
  • id (Field4)
  • title (Field)
  • content (Field2)
  • readcount (Field7)
  • store_name (Field8)
  • store_score (Field9)
  • store_area (Field10)
  • store_bestcount (Field11)
  • createdate (Field5)

GuideBoardComent (게시글 댓글)

  • coment_no (Field4) — Primary key
  • board_no (Key) — Primary key — NOT NULL
  • id (Field)
  • coment (Field2)
  • createdate (Field3)

GuideboardComentCount (댓글 좋아요)

  • coment_no (Field) — Primary key
  • id (Field2) — Primary key
  • likedate (Field3)

Reservation (찜 기능)

  • board_no (Field) — Primary key
  • id (Field2) — Primary key
  • clickdate (Field3)

Users (회원 테이블)

  • user_no (auto_increment) — Primary key
  • id (Key) — NOT NULL
  • password (Field)
  • nickname (Field2)
  • email (Field3)
  • phone (Field4)
  • type (Field5)
  • createdate (Field6)
  • logindate (Field7)