Innovation
Tables (5)
BUSINESS_CARD (Untitled)
- id (Key) — int — Primary key — NOT NULL
- company_name (Field2) — varchar(100)
- name (Field) — varchar(100)
- phone (Field3) — varchar(20)
- department (Field4) — varchar(50)
- job_title (Field5) — varchar(50)
- email (Field6) — varchar(100)
- office_phone (Field7) — varchar(20)
- office_fax (Field8) — varchar(20)
- office_address (Field9) — text
- registration_date (Field10) — date
- company_code (Key2) — varchar(50) — Foreign key → COMPANY.company_code — NOT NULL
COMPANY (Untitled2)
- company_code (Key) — varchar(50) — Primary key — NOT NULL
- name (Field) — varchar(100)
- type (Field2) — varchar(20)
- ceo_name (Field3) — varchar(100)
- address (Field4) — text
- phone (Field5) — varchar(20)
- founded (Field6) — date
- homepage (Field7) — varchar(100)
- capital (Field8) — decimal(15,2)
- employees (Field9) — int
INVESTMENT (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- investor_name (Field) — varchar(100)
- startup_name (Field2) — varchar(100)
- investment_date (Field3) — date
- amount (Field4) — decimal(15, 2)
- step (Field5)
- company_code (Key2) — varchar(50) — Foreign key → COMPANY.company_code — NOT NULL
- company_code (Key3) — varchar(50) — Foreign key → COMPANY.company_code — NOT NULL
PATENT (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- company_code (Key2) — varchar(50) — Foreign key → COMPANY.company_code — NOT NULL
- name (Field) — varchar(200)
- filing_date (Field2) — date
PRODUCT (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- company_code (Key2) — varchar(50) — Foreign key → COMPANY.company_code — NOT NULL
- name (Field) — varchar(100)
- description (Field2) — text
- tech (Field3) — varchar(100)
- field (Field4) — varchar(50)