빵터짐
테이블 (9)
빵집 (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
카테고리 (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 (hashtag) — longtext
- 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