SQL DDL to Gorm Model Converter

Convert SQL DDL statements to Go Gorm model structs with multiple database type mapping and tag generation

Data Type Mapping

String Types

  • VARCHAR, CHAR, TEXT → string
  • LONGTEXT, MEDIUMTEXT → string
  • ENUM → string

Number Types

  • INT, INTEGER → int
  • BIGINT → int64
  • SMALLINT → int16
  • TINYINT → int8
  • DECIMAL, NUMERIC → float64
  • FLOAT, DOUBLE → float64

Time Types

  • DATETIME, TIMESTAMP → time.Time
  • DATE → time.Time
  • TIME → time.Time

Other Types

  • BOOLEAN, BOOL → bool
  • BLOB, BINARY → []byte
  • JSON → json.RawMessage