TABLE
Tables (7)
AGENCY_FUNCTION (기관기능)
- AFNO (Key) — Primary key — NOT NULL
- AMNO (Key2) — Foreign key → AGENCY_MANAGEMENT.AMNO — NOT NULL
- READ (Field)
- WRITE (Field2)
AGENCY_INFORMATION (기관정보)
- AINO (Key) — Primary key — NOT NULL
- AMNO (Key2) — Foreign key → AGENCY_MANAGEMENT.AMNO — NOT NULL
- AGENCY_NAME (Field)
- CEO_NAME (Field9)
- SECTORS (Field2)
- QUATERNION (Field3)
- ES_YEAR (Field4)
- CORPORATE _TYPE (Field5)
- HOMEPAGE (Field6)
- ADDRESS (Field7)
- PHONE_NUMBER (Field8)
AGENCY_MANAGEMENT (기관목록)
- AMNO (Key) — Primary key — NOT NULL
- TITLE (Field)
- CONTENTS (Field2)
- REGDATE (Field3)
- UPDATEDATE (Field4)
- WRITER (Field5)
PROJECT (프로젝트)
- PNO (Key) — Primary key — NOT NULL
- AMNO (Key2) — Foreign key → AGENCY_MANAGEMENT.AMNO — NOT NULL
- NAME (Field)
- REPRESENTATIVE (Field2)
- START_DAY (Field4)
PROJECT_FUNCTION (프로젝트 기능)
- PFNO (Key) — Primary key — NOT NULL
- PNO (Key2) — Foreign key → PROJECT.PNO — NOT NULL
- AMNO (Key22) — Foreign key → PROJECT.AMNO — NOT NULL
- READ (Field)
- WRITE (Field2)
P_MEMBER (구성원)
- PMNO (Key) — Primary key — NOT NULL
- PNO (Key2) — Foreign key → PROJECT.PNO — NOT NULL
- AMNO (Key22) — Foreign key → PROJECT.AMNO — NOT NULL
- NAME (Field)
- POSITION (Field3)
- RANK (Field2)
- PHONE (Field4)
P_PROGRESS (프로젝트 진행상황)
- PPNO (Key) — Primary key — NOT NULL
- PNO (Key2) — Foreign key → PROJECT.PNO — NOT NULL
- AMNO (Key22) — Foreign key → PROJECT.AMNO — NOT NULL
- FRONT (Field)
- BACK (Field2)