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