최종예제
테이블 (8)
Untitled (FP_MEMBER)
- Key (MEMBER_NO) — NUMBER — 기본 키 — NOT NULL
- Field (MEMBER_ID) — VARCHAR2(20)
- Field (MEMBER_PW) — VARCHAR2(100)
- Field (MEMBER_NICK) — VARCHAR2(20)
- Field (MEMBER_GENDER) — VARCHAR2(1)
- Field (MEMBER_BIRTH) — DATE
- Field (MEMBER_PHONE) — VARCHAR2(30)
- Field (MEMBER_EMAIL) — VARHCAR2(100)
- Field (MEMBER_JOINDATE) — DATE
Untitled (FP_BOARD)
- Key (BOARD_NO) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (BOARD_TITLE) — VARCHAR2(200)
- Field (BOARD_CONTENT) — VARCHAR2(4000)
- Field (BOARD_READCOUNT) — NUMBER
- Field (BOARD_WRITEDATE) — DATE
Untitled (FP_HOBBY_CATEGORY)
- Key (HOBBY_CATEGORY_NO) — NUMBER — 기본 키 — NOT NULL
- Field (HOBBY_CATEGORY_NAME) — VARCHAR2(100)
Untitled (FP_MEMBERHOBBY)
- Key (MEMBERHOBBY_NO) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (HOBBY_CATEGORY_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
Untitled (FP_BOARDIMAGE)
- Key (IMAGE_NO) — NUMBER — 기본 키 — NOT NULL
- Key (BOARD_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (IMAGE_URL) — VARCHAR2(300)
- Field (IMAGE_ORIGINAL_FILENAME) — VARCHAR2(400)
Untitled (FP_MAILAUTH)
- Key (MAILAUTH_NO) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (MAILAUTH_KEY) — VARCHAR2(400)
- Field (MAILAUTH_COMPLETE) — VARCHAR2(1)
- Field (MAILAUTH_DATE) — DATE
Untitled (FP_BOARDLIKE)
- Key (LIKE_NO) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (BOARD_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (LIKE_DATE) — DATE
Untitled (FP_COMMENT)
- Key (COMMENT_NO) — NUMBER — 기본 키 — NOT NULL
- Key (BOARD_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (MEMBER_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (COMMENT_CONTENT) — VARCHAR2(1000)
- Field (COMMENT_WRITEDATE) — DATE