codingbook

테이블 (7)

UserMid (Untitled2)

  • email (Uk) — 80 — 기본 키 — NOT NULL
  • userNumber (PK) — 기본 키 — NOT NULL

board (Untitled5)

  • boardNumber (pk) — 기본 키 — NOT NULL
  • userNumber (PK) — 외래 키 → UserMid.userNumber — NOT NULL
  • likes (Field)
  • contents (Field2) — 300
  • created (Field4) — date

comment(댓글) (Untitled6)

  • comment_number (Key) — 기본 키 — NOT NULL
  • boardNumber (fk) — 외래 키 → board.boardNumber — NOT NULL
  • userNumber (PK) — 외래 키 → UserMid.userNumber — NOT NULL
  • likes (Field) — NUMBER
  • created (Field2) — Date
  • contents (Field3) — 80

joinUsers(외부로그인) (Untitled3)

  • domainNumber (Key) — 외래 키 → 도메인.domainNumber — NOT NULL
  • email (Uk) — 외래 키 → UserMid.email — NOT NULL
  • userNumber (PK) — 외래 키 → UserMid.userNumber — NOT NULL
  • name (Field3) — 20
  • created (Field4) — date

loginTimeCheck (Untitled7)

  • userNumber (PK) — 외래 키 → UserMid.userNumber — NOT NULL
  • time (Field) — date

도메인 (Untitled4)

  • domainNumber (Key) — 기본 키 — NOT NULL
  • name (Field) — 20

회원(users) (Untitled)

  • email (fk) — 외래 키 → UserMid.email — NOT NULL
  • userNumber (FK) — 외래 키 → UserMid.userNumber — NOT NULL
  • pw (Field2) — 65
  • name (Field3) — 20
  • created (Field4) — date