snsV3

Tables (5)

File (Untitled3)

  • file_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.post_id — NOT NULL
  • file_name (Field)

Like (Untitled5)

  • like_id (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → Member.member_idx — NOT NULL
  • post_id (Key3) — Foreign key → Post.post_id — NOT NULL

Member (Untitled)

  • member_idx (Key) — Primary key — NOT NULL
  • member_id (Field)
  • member_password (Field2)
  • member_phone (Field3)

Post (Untitled2)

  • post_id (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → Member.member_idx — NOT NULL
  • post_title (Field)
  • post_content (Field2)

Reply (Untitled4)

  • reply_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.post_id — NOT NULL
  • member_idx (Key3) — Foreign key → Member.member_idx — NOT NULL
  • reply_comment (Field)