ERDtest

Tables (22)

Copy Of Untitled (회원)

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

Copy Of Untitled2 (프로필)

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

Copy Of Untitled3 (글)

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

Copy Of Untitled4 (댓글)

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

Copy Of Untitled5 (친구)

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

Copy Of Untitled6 (좋아요)

  • Field (좋아요한 날짜)
  • Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (글번호) — Foreign key → Copy Of Untitled3.Key — NOT NULL

Untitled (write(글쓰기))

  • Field (memo_no) — int — Primary key
  • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (commant) — varchar
  • Field (memo) — varchar

Untitled

    Untitled (friend(친구))

    • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
    • Field (friend) — varchar

    Untitled (like(좋아요))

    • Key (like) — int — Primary key — NOT NULL
    • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
    • Field (memo_no) — int — Foreign key → Untitled.Field

    Untitled (replay(글보기))

    • Field (memo_no) — int — Foreign key → Untitled.Field
    • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
    • Key (like) — int — Foreign key → Untitled.Key — NOT NULL
    • Field (write_date) — date
    • Field (count) — int
    • Field (like_user) — varchar

    Untitled (member_pofile(프로필))

    • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
    • Field (school) — varchar
    • Field (com) — varchar

    Untitled (join(회원))

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

    Untitled (coa)

    • Field (coach) — varchar
    • Key (year) — int — Foreign key → Untitled.Key — NOT NULL
    • Field (winner) — varchar

    Untitled (cup)

    • Key (year) — int — Primary key — NOT NULL
    • Field (winner) — varchar

    Untitled (worldcup)

    • Key (year) — int — Primary key — NOT NULL
    • Field (winner) — varchar
    • Field (coach) — varchar

    Untitled (student_lec)

    • Field (grade) — varchar
    • Key (lecture) — varchar — NOT NULL
    • Key (no) — int — Foreign key → Untitled.Key — NOT NULL

    Untitled (student_cmp)

    • Key (no) — int — Primary key — NOT NULL
    • Field (campus) — varchar

    Untitled (student_lecture)

    • Key (no) — int — Primary key — NOT NULL
    • Field (lecture) — varchar — Primary key
    • Field (campus) — varchar
    • Field (grade) — varchar

    Untitled (phonebook)

    • Field (phone) — varchar
    • Key (id) — int — Foreign key → Untitled.Key — NOT NULL

    Untitled (member)

    • Key (id) — int — Primary key — NOT NULL
    • Field (name) — varchar

    profile

    • Key (id) — int — Primary key — NOT NULL
    • Field (name) — varchar
    • Field (phone1) — varchar
    • Field (phone2) — varchar