koric프로젝트

테이블 (11)

ADMIN_NOTICE (Untitled9)

  • AD_NOTICE_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • AD_NOTICE_TITLE (Field) — VARCHAR2(100)
  • AD_NOTICE_CONTENT (Field2) — CLOB
  • AD_NOTICE_IMG (Field3) — VARCHAR2(100)

ALERT (Untitled8)

  • ALTER_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • USER_IDX (USERIDX) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • ALERT_CONTENT (Field) — CLOB

CATEGORY (Untitled10)

  • PROJECT_IDX — NUMBER — 외래 키 → PROJECT.PROJECT_IDX — NOT NULL
  • CATEGORY_IDX (Key) — NUMBER — 외래 키 → CATEGORY_NAME.CATEGORY_IDX — NOT NULL

CATEGORY_NAME (Untitled11)

  • CATEGORY_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • CATEGORY_NAME (Field) — VARCHAR2(50)

CS (Untitled7)

  • CS_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • USER_IDX (USERIDX) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • CS_TITLE (Field) — VARCHAR2(100)
  • CS_CONTENT (Field2) — CLOB

DONATION (Untitled3)

  • PROJECT_IDX — NUMBER — 외래 키 → PROJECT.PROJECT_IDX — NOT NULL
  • USER_IDX (USERIDX) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • DONATION_MONEY (Field) — NUMBER

LIKE (Untitled5)

  • USER_IDX (USERIDX) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • PROJECT_IDX — NUMBER — 외래 키 → PROJECT.PROJECT_IDX — NOT NULL

NOTICE (Untitled6)

  • NOTICE_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • PROJECT_IDX — NUMBER — 외래 키 → PROJECT.PROJECT_IDX — NOT NULL
  • NOTICE_TITLE (Field3) — VARCHAR2(100
  • NOTICE_CONTENT (Field) — CLOB
  • NOTICE_IMG (Field2) — VARCHAR2(100)

PROJECT (Untitled2)

  • PROJECT_IDX — NUMBER — 기본 키 — NOT NULL
  • USER_IDX (USERIDX2) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • PROJECT_TITLE (Field7) — VARCHAR2(100)
  • PROJECT_CONTENT (Field) — CLOB
  • PROJECT_STATUS (Field2) — NUMBER
  • PROJECT_IMG (Field3) — VARCHAR2(100)
  • PROJECT_START (Field4) — DATE
  • PROJECT_END (Field5) — DATE
  • PROJECT_TARGET (Field6) — NUMBER

REVIEW (Untitled4)

  • REVIEW_IDX (Key) — NUMBER — 기본 키 — NOT NULL
  • PROJECT_IDX — NUMBER — 외래 키 → PROJECT.PROJECT_IDX — NOT NULL
  • USER_IDX (USERIDX) — NUMBER — 외래 키 → USER.USER_IDX — NOT NULL
  • REVIEW_CONTENT (Field) — CLOB

USER (Untitled)

  • USER_IDX (USERIDX) — NUMBER — 기본 키 — NOT NULL
  • USER_GRADE (A) — NUMBER
  • USER_EMAIL (EMAIL) — VARCHAR2(100)
  • USER_NAME (NAME) — VARCHAR2(100)
  • USER_PW (PWD) — VARCHAR2(100)
  • USER_IMG — VARCHAR2(100)
  • USER_STATUS (Field6) — NUMBER
  • USER_CONTENT — VARCHAR2(100)
  • USER_ADDR — VARCHAR2(100)
  • USER_POINT — NUMBER