main-project
Tables (8)
Cafe (Untitled)
- cafe_id (카페 id) — BIGINT — Primary key — NOT NULL
- cafe_nm (카페명) — VARCHAR(20) — NOT NULL
- cafe_addr (주소) — VARCHAR(50) — NOT NULL
- cafe_phn (전화번호) — VARCHAR(50)
- cafe_url (홈페이지) — VARCHAR(50)
- cafe_dsrp (카페 설명) — VARCHAR — NOT NULL
- cafe_bdg (관리자 인증 여부) — BOOLEAN — NOT NULL
- open_tm (오픈 시간) — TIMESTAMP — NOT NULL
- close_tm (마감 시간) — TIMESTAMP — NOT NULL
- like_cnt (찜 수) — BIGINT — NOT NULL
- rvw_cnt (리뷰 수) — BIGINT — NOT NULL
- mn_img_id (메인 이미지) — BIGINT
- mu_img_id (메뉴 이미지) — BIGINT
CafeTag (Untitled6)
- cafetag_id (카페태그 id) — BIGINT — Primary key — NOT NULL
- cafe_id (카페 id) — BIGINT — Foreign key → Cafe.cafe_id — NOT NULL
- tag_id (태그id) — BIGINT — Foreign key → Tag.tag_id — NOT NULL
Image (Untitled4)
- image_id (이미지 id) — BIGINT — Primary key — NOT NULL
- path (주소) — VARCHAR(50) — NOT NULL
- status (상태) — BIGINT — NOT NULL
Like (Untitled8)
- like_id (찜 id) — BIGINT — Primary key — NOT NULL
- cafe_id (카페 id) — BIGINT — Foreign key → Cafe.cafe_id — NOT NULL
- user_id (유저 id) — BIGINT — Foreign key → User.user_id — NOT NULL
Review (Untitled3)
- rvw_id (리뷰 id) — BIGINT — Primary key — NOT NULL
- cafe_id (카페 id) — BIGINT — Foreign key → Cafe.cafe_id — NOT NULL
- image_id (리뷰 이미지 id) — BIGINT — Foreign key → Image.image_id — NOT NULL
- user_id (작성자 id) — BIGINT — Foreign key → User.user_id — NOT NULL
- rvw_dsrp (한줄평) — VARCHAR
- score (별점) — BIGINT — NOT NULL
- reg_dt (등록 날짜) — TIMESTAMP — NOT NULL
- mdf_dt (수정 날짜) — TIMESTAMP — NOT NULL
ReviewTag (Untitled7)
- rvwtag_id (리뷰태그 id) — BIGINT — Primary key — NOT NULL
- rvw_id (리뷰 id) — BIGINT — Foreign key → Review.rvw_id — NOT NULL
- tag_id (태그id) — BIGINT — Foreign key → Tag.tag_id — NOT NULL
Tag (Untitled5)
- tag_id (태그 id) — BIGINT — Primary key — NOT NULL
- tag_nm (태그 이름) — VARCHAR(20) — NOT NULL
- tag_ctg (태그 종류) — VARCHAR(20) — NOT NULL
User (Untitled2)
- user_id (유저 id) — BIGINT — Primary key — NOT NULL
- prf_pf (프로필 이미지 id) — BIGINT — Foreign key → Image.image_id — NOT NULL
- email (유저 이메일) — VARCHAR(50) — NOT NULL
- user_nm (유저 이름) — VARCHAR(20) — NOT NULL
- user_pw (패스워드) — VARCHAR — NOT NULL
- mobile (휴대폰 번호) — VARCHAR(20)
- role (회원 권한) — VARCHAR(10) — NOT NULL
- status (회원 상태) — VARCHAR(10) — NOT NULL
- reg_dt (가입 날짜) — TIMESTAMP — NOT NULL