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