test1

Tables (4)

Untitled (회원정보)

  • Key (아이디) — varchar — Primary key — NOT NULL
  • Field (비밀번호) — varchar
  • Field (주소) — varchar
  • Field (이메일) — varchar
  • Field (연락처) — int
  • Field (계좌번호) — int

Untitled (내 프로필)

  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (사진)
  • Field (닉네임)

Untitled (친구)

  • Field (친구번호) — int — Primary key
  • Field (친구연락처) — int
  • Field (친구이름) — varchar
  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (친구닉네임) — varchar
  • Field (친구사진)
  • Field (친구생일) — varchar
  • Field

Untitled (채팅)

  • Key (채팅번호) — int — Primary key — NOT NULL
  • Key (아이디) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (친구번호) — int — Foreign key → Untitled.Field
  • Field (내용) — varchar