nomalize

Tables (21)

Untitled (profil_e)

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

Untitled (좋아요)

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

Untitled (친구)

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

Untitled (댓글)

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

Untitled (글)

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

Untitled (프로필)

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

Untitled (회원)

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

Untitled (글 읽기)

  • Key (글번호) — int — Primary key — NOT NULL
  • Field (id) — varchar
  • Field (등록날짜) — date
  • Field (글 내용) — varchar
  • Field (조회 수) — int
  • Field (좋아요) — int

Untitled (like)

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

Untitled (reply)

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

Untitled (글 작성)

  • Key (w_no) — int — Primary key — NOT NULL
  • Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (등록날짜) — date
  • Field (글 내용) — varchar

Untitled (profile)

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

Untitled (user)

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

Untitled (worldcup_team)

  • Field (nation) — varchar
  • Field2 (coach) — varchar

Untitled (worldcup_win)

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

Untitled (worldcup)

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

Untitled (lectures)

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

Untitled (student)

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

Untitled (student_lecture)

  • Key (no) — int — Primary key — NOT NULL
  • Key (lecture) — varchar — Primary key — NOT NULL
  • 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