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)