Design

Tables (6)

Untitled (회원)

  • Key (아이디) — varchar — Primary key — NOT NULL
  • Field (비밀번호) — varchar
  • Field (이메일) — varchar
  • Field (이름) — varchar
  • Field (등록날짜) — date

Untitled (프로필)

  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (학교) — varchar
  • Field (회사) — varchar

Untitled (친구목록)

  • Field (친구아이디) — varchar
  • Field (관계) — varchar
  • Field (등록날짜) — date
  • Key (아이디2) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (글)

  • Key (글번호) — int — Primary key — NOT NULL
  • Field (등록날짜) — date
  • Field (좋아요) — int
  • Field (조회수) — int
  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (댓글)

  • Key (댓글번호) — int — Primary key — NOT NULL
  • Field (내용) — varchar
  • Key (글번호2) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (좋아요)

  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (글번호) — int — Foreign key → Untitled.Key — NOT NULL