test

Tables (6)

Untitled (회원)

  • Key (id) — varchar(20) — Primary key — NOT NULL
  • Field (pw) — varchar(20)
  • Field (email) — varchar(50)
  • Field (name) — varchar(10)

Untitled (프로필)

  • Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (학교) — varchar(15)
  • Field (회사) — varchar(15)
  • Field (등록일)

Untitled (글)

  • Key (글번호) — int(1000) auto_increment — Primary key — NOT NULL
  • Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (멘트) — varchar(300)
  • Field (등록날짜) — date default current_date
  • Field (조회수) — int(100)
  • Field (등록일)

Untitled2 (댓글)

  • Key (댓글번호) — Primary key — NOT NULL
  • Field (내용)
  • Key (글번호) — int(1000) auto_increment — Foreign key → Untitled.Key — NOT NULL
  • Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (등록일)

Untitled3 (친구목록)

  • Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (친구id)
  • Field (관계)
  • Field (등록일)

Untitled3 (좋아요)

  • Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (글번호) — int(1000) auto_increment — Foreign key → Untitled.Key — NOT NULL
  • Field (등록일)