test

테이블 (4)

게시판 (tbl_board)

  • seq (Key) — 기본 키 — NOT NULL
  • category_board (Field)
  • writer (Field2)
  • writer_id (Field3)
  • title (Field4)
  • content (Field5)
  • write_date (Field6)
  • view_count (Field7)
  • recommend_count (Field8)

사업자회원 (CopyOftbl_member)

  • category_mem (Field7) — 기본 키
  • id (Key) — 기본 키 — NOT NULL
  • signup_num (Key2) — 외래 키 → 센터정보.signup_num — NOT NULL
  • pw (Field)
  • email (Field2)
  • nickname (Field3)
  • phone (Field4)
  • address (Field5)
  • signup_date (Field6)

센터정보 (tbl_fitness)

  • signup_num (Key) — 기본 키 — NOT NULL
  • center_name (Field)
  • center_address (Field4)
  • category_exercise (Field2)
  • price (Field3)

회원 (tbl_member)

  • category_mem (Field7) — 기본 키
  • id (Key) — 기본 키 — NOT NULL
  • pw (Field)
  • email (Field2)
  • nickname (Field3)
  • phone (Field4)
  • address (Field5)
  • signup_date (Field6)