practice

테이블 (6)

Untitled (모각코 게시판 댓글)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (contents) — NN
  • Field2 (commenter) — NN
  • Field3 (created_at)
  • Field4 (updated_at)

Untitled (캘린더)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Untitled (채팅정보(그룹))

  • Key (channel_id) — PK — 기본 키 — NOT NULL
  • Field (message_id) — PK
  • Field2 (message_to) — PK
  • Field3 (contents) — NN
  • Field (created_at)

Untitled2 (모각코 게시판)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (title) — NN
  • Field2 (contents) — NN
  • Field4 (author) — NN
  • Field (view_count) — 0
  • Field (comment_count) — 0
  • Field3 (created_at)
  • Field (updated_at)
  • Field (status) — NN

채팅 메세지 정보 (채팅정보(1:1의 경우))

  • id — PK — 기본 키 — NOT NULL
  • message_from — PK
  • message_to — PK
  • Field (contents) — NN
  • Field2 (created_at)

회원정보

  • 유저식별자 (id) — PK — 기본 키 — NOT NULL
  • Field (Nickname) — NN
  • Field3 (email)
  • Field4 (password) — NN
  • Field (created_at)