연습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)

Untitled2 (TOSSPAY)

    Untitled3 (ORDERPAY)