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)