연습1
테이블 (10)
Copy Of Untitled (ADMIN)
- Key (ADMIN_ID) — VARCHAR2(100) — 기본 키 — NOT NULL
- Field (PWD) — VARCHAR2(100)
- Field (NICK) — VARCHAR2(100)
- Field (NAME) — VARCHAR2(1000)
- Field (PROFILE) — VARCHAR2(1000)
- Field (INTRODUCE) — VARCHAR2(1000)
Copy Of Untitled2 (BOARD)
- Key (BOARD_NO) — NUMBER — 기본 키 — NOT NULL
- Key (WRITER_ID) — VARCHAR2(100) — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Field (BOARD_TITLE) — VARCHAR2(2000)
- Field (BOARD_CONTENT) — VARCHAR2(10000)
- Field (BOARD_VIEW_CNT) — NUMBER
- Field (BOARD_IMG) — VARCHAR2(100)
- Field (DELETE_YN) — CHAR(1)
- Field (DELETE_DATE) — DATE
- Field (UPDATE_DATE) — DATE
- Field (CREATE_DATE) — DATE
Untitled (MEMBER)
- Key (MEMBER_ID) — VARCHAR2(100) — 기본 키 — NOT NULL
- Field (PWD) — VARCHAR2(100)
- Field (NICK) — VARCHAR2(100)
- Field (NAME) — VARCHAR2(1000)
- Field (PROFILE) — VARCHAR2(1000)
- Field (INTRODUCE) — VARCHAR2(2000)
- Field (LEVEL) — CHAR(1)
- Field (ADDRESS) — VARCHAR2(2000)
- Field (PHONE) — CHAR(11)
- Field (DELETE_YN) — CHAR(1)
- Field (ENROLL_DATE) — TIMESTAMP
Untitled (NOTICE)
- Key (NOTICE_NO) — NUMBER — 기본 키 — NOT NULL
- Key (ADMIN_ID) — VARCHAR2(10) — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Field (NOTICE_TITLE) — VARCHAR2(1000)
- Field (NOTICE_CONTENT) — VARCHAR2(5000)
- Field (NOTICE_VIEW_CNT) — NUMBER
- Field (NOTICE_IMG) — VARCHAR2(1000)
- Field (DELETE_YN) — CHAR(1)
- Field (DELETE_DATE) — DATE
- Field (CREATE_DATE) — DATE
- Field (UPDATE_DATE) — DATE
Untitled (LIKE)
- Key (LIKE_NO) — NUMBER — 기본 키 — NOT NULL
- Key (NOTICE_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (COMMENT)
- Key (COMMENT_ID) — NUMBER — 기본 키 — NOT NULL
- Key (COM_WRITER_ID) — VARCHAR2(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (BOARD_NO) — NUMBER — 외래 키 → Copy Of Untitled2.Key — NOT NULL
- Field (COM_CONTENT) — VARCHAR2(4000)
- Field (DELETE_YN) — CHAR(1)
- Field (DELETE_DATE) — DATE
- Field (CREATE_DATE) — DATE
- Field (UPDATE_DATE) — DATE
Untitled (ORDER)
- Key (ORD_ID) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (MD_ID) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (ORD_NO) — NUMBER
- Field (STATUS) — VARCHAR2(300)
- Field (AMOUNT)
Untitled (MD)
- Key (MD_ID) — NUMBER — 기본 키 — NOT NULL
- Field (MD_NAME) — VARCHAR2(1000)
- Field (PRICE) — NIMBER
- Field (MD_IMG) — VARCHAR2(100)