design1

Tables (6)

Untitled (회원)

  • Field (아이디) — Primary key
  • Field (비밀번호)
  • Field (이메일)
  • Field (이름)

Untitled (프로필)

  • Field (학교)
  • Field (회사)
  • Field (작성일)
  • Field (아이디) — Foreign key → Untitled.Field

Untitled (글)

  • Field (글번호) — Primary key
  • Field (멘트)
  • Field (조회수)
  • Field (좋아요)
  • Field (등록날짜)
  • Field (아이디) — Foreign key → Untitled.Field

Untitled (댓글)

  • Key (댓글번호) — Primary key — NOT NULL
  • Field (글번호) — Foreign key → Untitled.Field
  • Field (내용)
  • Field (작성일)
  • Field (아이디) — Foreign key → Untitled.Field

Untitled (친구)

  • Field (친구번호) — Primary key
  • Field (아이디) — Foreign key → Untitled.Field
  • Field (친구아이디)
  • Field (친구맺은날짜)
  • Field (관계)

Untitled (좋아요)

  • Field (좋아요 한날짜)
  • Field (글번호) — Foreign key → Untitled.Field
  • Field (아이디) — Foreign key → Untitled.Field