연습

테이블 (8)

Copy Of username (CopyOfUntitled4)

book (CopyOfUntitled6)

  • book_id (id) — 기본 키 — NOT NULL
  • title
  • author (author_id)
  • rental_date (date) — 12-12-12
  • member_id — 외래 키 → member.member_id — NOT NULL
  • category_id — 외래 키 → category.category_id — NOT NULL

category (Untitled2)

  • category_id (Key) — 기본 키 — NOT NULL
  • category_name (Field)

category (Untitled5)

  • category_id (id) — 기본 키 — NOT NULL
  • category_name

member (Untitled)

  • member_id — 기본 키 — NOT NULL
  • email
  • password
  • username

member (Untitled6)

  • member_id (id) — 기본 키 — NOT NULL
  • name (name_id)
  • phone (p_num)
  • email (email_num)

post (Untitled3)

  • post_id — 기본 키 — NOT NULL
  • title
  • content
  • created_at (cteated_at)
  • member_id — 외래 키 → member.member_id — NOT NULL
  • category_id — 외래 키 → category.category_id — NOT NULL

username (Untitled4)