GGGI

Tables (7)

ACTIVITY_LOG (Untitled4)

  • LOG_ID — BIGINT — Primary key — NOT NULL — PK
  • ACTION_TYPE (Field) — ENUM — NOT NULL — SUBMIT/ASSIGN/STATUS_CHANGE /REVSION_REQUEST/DELETE
  • FROM_STATUS (Field2) — VARCHAR
  • TO_STATUS (Field3) — VARCHAR
  • REASON (Field4) — TEXT — NOT NULL — 반려, 보완, 삭제 사유
  • CREATED_AT (Field6) — DATETIME — NOT NULL
  • ACTOR_ID (Key) — BIGINT — Foreign key → USER.USER_ID — NOT NULL — FK
  • PROPOSAL_ID (2) — BIGINT — Foreign key → PROPOSAL.PROPOSAL_ID — NOT NULL — FK

ATTACHMENT (Untitled3)

  • ATTACHMENT_ID (Key) — BIGINT — Primary key — PK
  • FILENAME (Field) — VARCHAR(50) — NOT NULL
  • MIME_TYPE (Field2) — ENUM — NOT NULL — PDF/PNG/JPEG
  • FILE_SIZE (Field3) — INT — NOT NULL
  • UPLOADED_AT (Key2) — DATETIME
  • STORAGE_PATH (Key4) — VARCHAR — NOT NULL
  • PROPOSAL_ID (2) — BIGINT — Foreign key → PROPOSAL.PROPOSAL_ID — NOT NULL — FK

PROPOSAL (Untitled2)

  • PROPOSAL_ID — BIGINT — Primary key — NOT NULL — PK
  • PROPOSAL_NO (Field2) — VARCHAR(20) — NOT NULL — UK
  • CONTACT_PERSON (Field3) — VARCHAR(20) — NOT NULL
  • CONTACT_TITLE (Field4) — VARCHAR(20) — NOT NULL
  • PROJECT_TITLE (Key) — VARCHAR(50) — NOT NULL
  • SECTOR (Key2) — VARCHAR(20)
  • WINDOW_CODE (Field5) — ENUM — NOT NULL — W1/W2/W3
  • INTL_PARTNERSHIP (Field6) — ENUM — NOT NULL — Y/N
  • COUNTRY_RATIONALE (Field7) — TEXT — NOT NULL
  • PROBLEM_GAP (Field8) — TEXT — NOT NULL
  • TRL (Field9) — SMALLINT — NOT NULL — 1 - 9
  • CRL (Field10) — SMALLINT — NOT NULL — 1 - 9
  • PILOT_EXPERIENCE (Field11) — ENUM — NOT NULL — Y/N
  • UNIQUENESS (Field12) — TEXT — NOT NULL
  • LOCAL_BENEFITS (Field13) — TEXT — NOT NULL
  • SCALEUP_POTENTIAL (Field14) — TEXT — NOT NULL
  • FINANCING_RATIONALE (Field15) — TEXT — NOT NULL
  • RISK_REGULATORY (Field16) — TEXT — NOT NULL
  • RISK_CLIMATE (Field17) — TEXT — NOT NULL
  • PATENT_PLAN (Field18) — TEXT
  • COMM_STATEGY (Field19) — TEXT
  • TOTAL_CHAR_COUNT (Field20) — INT — NOT NULL
  • RECEIVED_AT (Field21) — DATETIME — NOT NULL
  • CREATED_AT (Field22) — DATETIME — NOT NULL
  • UPDATED_AT (Field23) — DATETIME — NOT NULL
  • PROPOSER_ID (Key3) — BIGINT — Foreign key → USER.USER_ID — NOT NULL — FK

PROPOSAL_COUNTRY (Untitled6)

  • PROPOSAL_ID (Key) — BIGINT — Primary key — NOT NULL — PK
  • COUNTRYCODE (Key2) — VARCHAR — Primary key — NOT NULL — PK, FK
  • IS_PRIMARY (Field) — BOOLEAN — NOT NULL
  • PROPOSAL_ID (2) — BIGINT — Foreign key → PROPOSAL.PROPOSAL_ID — NOT NULL — FK

PROPOSAL_FINANCING (Untitled7)

  • PROPOSAL_ID (Key) — BIGINT — Primary key — NOT NULL — PK
  • OPTION_CODE (Key2) — VARCHAR(50) — Primary key — NOT NULL — PK, FK
  • SPECIFY_TEXT (Field3) — TEXT — NOT NULL
  • PROPOSAL_ID (2) — BIGINT — Foreign key → PROPOSAL.PROPOSAL_ID — NOT NULL — FK

PROPOSAL_REVIEW (Untitled5)

  • PROPOSAL_ID (Key) — BIGINT — Primary key — NOT NULL — PK
  • STATUS (Field) — ENUM — NOT NULL — RECEIVED/IN_REVIEW_/REVISION_REQUESTED/APPROVED/REJECTED/DELETED
  • ASSIGNED_AT (Field2) — DATETIME
  • INTERNAL_NOTE (Field3) — TEXT
  • DECESION_REASON (Field4) — TEXT — REVISION_REQUESTED/REJECTED
  • DECIDED_AT (Field5) — DATETIME
  • IS_DELETED (Field6) — BOOLEAN — NOT NULL — DEFAULT: FALSE
  • DELETE_REASON (Field7) — ENUM — 중복제출/대상외/자진철회/기타
  • UPDATED_AT (Field8) — DATETIME
  • REVIEWER_ID (Key3) — BIGINT — Foreign key → USER.USER_ID — FK
  • PROPOSAL_ID (2) — BIGINT — Foreign key → PROPOSAL.PROPOSAL_ID — NOT NULL — FK

USER (Untitled)

  • USER_ID (Key) — BIGINT — Primary key — NOT NULL — PK
  • EMAIL (Field2) — VARCHAR(30) — NOT NULL — UK
  • NAME (Field3) — VARCHAR(30) — NOT NULL
  • JOB_TITLE (Field4) — VARCHAR(20)
  • ORGANIZATION (Field5) — ENUM — NOT NULL — 제안기관/GGGI
  • ROLE (Field6) — ENUM — NOT NULL — PROPOSER/ADMIN/REVIEWER
  • IS_ACTIVE (Field7) — BOOLEAN — NOT NULL — DEFAULT: TRUE
  • CREATED_AT (Field8) — DATE_TIME — NOT NULL