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