withbakery

테이블 (10)

빵집 (bakerystore)

  • Key (id) — long — 기본 키 — NOT NULL
  • Field (entrp_nm) — varchar
  • Field (load_addr) — varchar
  • Field (city_do_cd) — varchar
  • Field (city_gn_gu_cd) — varchar
  • Field (xpos_io) — varchar
  • Field (ypos_io) — varchar
  • Field (area_nm) — varchar
  • Field (hompage_url) — varchar
  • Field (tel_no) — varchar
  • Field (represent_menu_nm) — varchar
  • Field (menu_pc) — varchar
  • Field (base_ymd) — datetime
  • Field (image) — blob
  • Field (lookup_cnt) — int

빵집검색리스트 (search_breadstore)

    빵집메뉴 (breadstoremenu)

    • Key (menu_id) — long — 기본 키 — NOT NULL
    • Key (id) — long — 외래 키 → 빵집.Key — NOT NULL
    • Field (menu_nm) — varchar
    • Field (menu_price) — varchar

    빵집평점 (store_grade)

    • Key (id) — long — 외래 키 → 사용자.Key — NOT NULL
    • Key (id2) — long — 외래 키 → 빵집.Key — NOT NULL
    • Field (star) — long
    • Field (comment) — varchar
    • Field (create_time) — datetime
    • Field (update_time) — datetime
    • Field (del_yn) — char

    사용자 (user)

    • Key (id) — long — 기본 키 — NOT NULL
    • Field (email) — varchar
    • Field (nickname) — varchar
    • Field (password) — varchar
    • Field (profile_img) — varchar
    • Field (create_time) — datetime
    • Field (update_time) — datetime
    • Field (del_yn) — char
    • Field (role) — varchar

    접속관리 (connect_mng)

      카테고리 (content_category)

      • Key (id) — long — 기본 키 — NOT NULL
      • Field (name) — varchar
      • Field (create_tiem) — datetime
      • Field (update_time) — datetime
      • Field (code) — varchar

      컨텐츠 (contents)

      • Key (id) — long — 기본 키 — NOT NULL
      • Key (id2) — long — 외래 키 → 사용자.Key — NOT NULL
      • Key (id3) — long — 외래 키 → 카테고리.Key — NOT NULL
      • Field (title) — varchar
      • Field (content) — varchar
      • Field (create_tiem) — datetime
      • Field (update_time) — datetime
      • Field (del_yn) — char

      컨텐츠파일 (contents_file)

      • Key (id) — long — 기본 키 — NOT NULL
      • Key (id2) — long — 외래 키 → 컨텐츠.Key — NOT NULL
      • Field (file_name) — vachar
      • Field (filesize) — long
      • Field (url) — varchar
      • Field (imageExtension) — varchar

      해시태그 (hashtag)