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