고기로3

테이블 (13)

t_bookmark

  • iuser — int(10) — 외래 키 → t_user.iuser — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • created_at — datetime

t_category

  • imeat — int(10) — 기본 키 — NOT NULL
  • mtype — varchar(20) — NOT NULL

t_commu

  • iboard — int(10) — 기본 키 — NOT NULL
  • iuser — int(10) — 외래 키 → t_user.iuser — NOT NULL
  • title — varchar(50) — NOT NULL
  • contents — varchar(100) — NOT NULL

t_commu_pics

  • icommu_pics — int(10) — 기본 키 — NOT NULL
  • iboard — int(10) — 외래 키 → t_commu.iboard — NOT NULL
  • pic — varchar(3000) — NOT NULL

t_menu

  • ishop_menu — int(10) — 기본 키 — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • menu — varchar(100) — NOT NULL

t_menu_pics

  • imenu_pics — int(10) — 기본 키 — NOT NULL
  • ishop_menu — int(10) — 외래 키 → t_menu.ishop_menu — NOT NULL
  • pic — varchar(3000) — NOT NULL

t_pickup

  • ibutcher — int(10) — 기본 키 — NOT NULL
  • iuser — int(10) — 외래 키 → t_user.iuser — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • bu_time — datetime — NOT NULL
  • requset — varchar(50)
  • order — varchar(100) — NOT NULL

t_reservation

  • ireser — int(10) — 기본 키 — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • iuser — int(10) — 외래 키 → t_user.iuser — NOT NULL
  • re_time — datetime — NOT NULL
  • request — varchar(50)

t_review_pics

  • ireview_pics — int(10) — 기본 키 — NOT NULL
  • ireview (ireview2) — int(10) — 외래 키 → t_shop_review.ireview — NOT NULL
  • r_pic — varchar(3000) — NOT NULL

t_shop

  • ishop — int(10) — 기본 키 — NOT NULL
  • imeat — int(10) — 외래 키 → t_category.imeat — NOT NULL
  • location — varchar(50) — NOT NULL
  • facilities — varchar(50) — NOT NULL
  • open — varchar(50) — NOT NULL
  • tel — varchar(50) — NOT NULL
  • introduction — varchar(50) — NOT NULL
  • check_shop — tinyint(1) — NOT NULL

t_shop_pics

  • ishop_pics — int(10) — 기본 키 — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • pic — varchar(3000) — NOT NULL

t_shop_review

  • ireview — int(10) — 기본 키 — NOT NULL
  • ishop — int(10) — 외래 키 → t_shop.ishop — NOT NULL
  • star — smallint(10) — NOT NULL
  • review — varchar(100) — NOT NULL

t_user

  • iuser — int(10) — 기본 키 — NOT NULL
  • email — varchar(50) — NOT NULL
  • upw — varchar(50) — NOT NULL
  • name — varchar(10) — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • birth — varchar(20) — NOT NULL
  • gender — varchar(1)
  • residence — varchar(50) — NOT NULL
  • pic — varchar(3000)
  • created_at — datetime