부추_DB설계

테이블 (3)

Admin (Untitled2)

  • adminid (Key) — 기본 키 — NOT NULL
  • name (Field)

posts (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • tableid (Key2) — 외래 키 → table.tableid — NOT NULL
  • place (Field)
  • title (Field2)
  • subtitle (Field3)
  • main_place (Field4)
  • addr1 (Field5)
  • addr2 (Field6)
  • cntct_tcl (Field7)
  • homepage_url (Field8)
  • trfc_info (Field9)
  • usage_day (Field10)
  • usage_day_week_and_time (Field11)
  • usage_amount (Field12)
  • main_img_normal (Field13)
  • main_img_thumb (Field14)
  • itemcntnts (Field15)

table (Untitled)

  • tableid (Key) — 기본 키 — NOT NULL
  • postid (FK)