Blog

Tables (6)

Cafe_Review (Untitled6)

  • Cafe_name (Key) — Primary key — NOT NULL
  • Rating (Field)
  • Content_Text (Field2)
  • Post_ID (Key2) — Foreign key → Post.Post_ID — NOT NULL

Cafe_info (Untitled5)

  • Cafe_name (Key) — Primary key — NOT NULL
  • Address (Field)
  • Phone (Field2)
  • Image_Url (Field3)
  • Content_Text (Field4)
  • Post_ID (Key2) — Foreign key → Post.Post_ID — NOT NULL

Comment (Untitled3)

  • Commnet_ID (Key) — Primary key — NOT NULL
  • Post_ID (Key2) — Foreign key → Post.Post_ID — NOT NULL
  • ID (Key3) — Foreign key → User.ID — NOT NULL

Post (Untitled2)

  • Post_ID (Key) — Primary key — NOT NULL
  • Title (Field2)
  • Content_Text (Field3)
  • Cafe_ID (Field4)
  • ID (Key2) — Foreign key → User.ID — NOT NULL

Tag (Untitled4)

  • Tag_ID (Key) — Primary key — NOT NULL
  • Post_ID (Key2) — Foreign key → Post.Post_ID — NOT NULL
  • ID (Key3) — Foreign key → User.ID — NOT NULL

User (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field2)
  • Password (Field3)