최종예제 게시판
테이블 (8)
Copy Of Untitled (CopyOfMember)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Field (id) — VARCHAR2(40)
- Field (pw) — VARCHAR2(200)
- Field2 (nick) — VARCHAR2(40)
- Field (gender) — VARCHAR2(2)
- Field (birth) — DATE
- Field (phone) — VARCHAR2(20)
- Field (email) — VARCHAR2(100)
- Field (joindate) — DATE
MailAuth
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (key) — VARCHAR2(200)
- Field (complete) — VARCHAR2(4)
- Field (date) — DATE
Untitled (Member)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Field (id) — VARCHAR2(40)
- Field (pw) — VARCHAR2(200)
- Field2 (nick) — VARCHAR2(40)
- Field (gender) — VARCHAR2(2)
- Field (birth) — DATE
- Field (phone) — VARCHAR2(20)
- Field (email) — VARCHAR2(100)
- Field (joindate) — DATE
Untitled (Board)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — VARCHAR2(400)
- Field2 (content) — VARCHAR2(4000)
- Field (readcount) — NUMBER
- Field (writedate) — DATE
Untitled (hobby)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (hobby_category_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
Untitled (hobby_category)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Field (name) — VARCHAR2(40)
Untitled (Board_Image)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Key (board_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (link) — VARCHAR2(100)
- Field (original_fileName) — VARCHAR2(100)
Untitled (Board_Like)
- Key (no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (board_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (date) — DATE