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)