ERD-1

테이블 (7)

article (Untitled4)

  • aid (Key) — intger — 기본 키 — NOT NULL
  • bid (Key2) — integer — 외래 키 → board.bid — NOT NULL
  • uid — Integer — 외래 키 → user.uid — NOT NULL
  • title (Field) — varchar(50) — NOT NULL
  • content (Field2) — text — NOT NULL

article_like (Untitled7)

    board (Untitled3)

    • bid (Key) — integer — 기본 키 — NOT NULL
    • bname (Field) — varchar(30) — NOT NULL

    comment (Untitled5)

    • cid (Key) — integer — 기본 키 — NOT NULL
    • aid (Key3) — intger — 외래 키 → article.aid — NOT NULL
    • uid — Integer — 외래 키 → user.uid — NOT NULL
    • content (Field) — varchar(200) — NOT NULL

    email_confirm (Untitled2)

    • email (Key2) — varchar(30) — 기본 키 — NOT NULL
    • expire (Key3) — datetime — NOT NULL
    • secured_key (Field) — varchar(30) — NOT NULL

    user (Untitled)

    • uid — Integer — 기본 키 — NOT NULL
    • id — varchar(20) — NOT NULL — UNIQUE
    • pw — varchar(255)
    • nickname — varchar(20) — UNIQUE
    • name (Field) — varchar(20) — NOT NULL
    • 기수 (Field2) — integer — NOT NULL
    • track (Field3) — varchar(20) — NOT NULL
    • profile_image (Field4) — image
    • joined_at (Field5) — datetime — NOT NULL
    • logined_at (Field6) — datetime
    • email (Field7) — varchar(30) — NOT NULL — UNIQUE

    대댓글 (Untitled6)

    • ccid (Key) — integer — 기본 키 — NOT NULL
    • cid (Key2) — integer — 외래 키 → comment.cid — NOT NULL
    • uid — Integer — 외래 키 → user.uid — NOT NULL
    • content (Field) — varchar(100) — NOT NULL