{{Extend "db/index"}} {{Block "title"}}{{"数据库"|T}}: {{Stored.dbName}} - {{Super}}{{/Block}} {{Block "breadcrumb"}} {{Super}}
  • {{"数据库"|T}}: {{Stored.dbName}}
  • {{"表"|T}}: {{Stored.table}}
  • {{/Block}} {{Block "main"}} {{$table := Stored.table}}
    {{Include "db/mysql/results"}}

    {{"表结构"|T}}: {{$table}}

    {{if Stored.tableStatus.Comment.Valid}}
    {{"注释"|T}}: {{Stored.tableStatus.Comment.String}}
    {{end}}
    {{range $k,$v := Stored.postFields}} {{end}}
    {{"列"|T}} {{"类型"|T}} {{"注释"|T}}
    {{$v.Field}} {{$v.Full_type}} {{if $v.Null}}NULL{{end}} {{if $v.AutoIncrement.Valid}}{{"自动增量"|T}}{{end}} {{if $v.Default.Valid}}[{{$v.Default.String}}]{{end}} {{if $v.On_update}}ON UPDATE {{$v.On_update}}{{end}} {{$v.Comment}}
    {{if not Stored.tableStatus.IsView}}
    {{"修改索引"|T}}

    {{"索引"|T}}

    {{range $k,$v := Stored.indexes}} {{end}}
    {{"类型"|T}} {{"列"|T}} {{"名称"|T}}
    {{$v.Type}} {{range $i,$r := $v.Columns}} {{if gt $i 0}}, {{end}} {{$r}} {{$length := index $v.Lengths $i}} {{$desc := index $v.Descs $i}} {{if $length}}({{$length}}){{end}} {{if eq $desc `DESC`}} DESC{{end}} {{end}} {{if $v.With}} WITH {{$v.With}}{{end}} {{$v.Name}}
    {{end}} {{if Stored.tableStatus.FKSupport Stored.version}}
    {{"添加外键"|T}}

    {{"外键"|T}}

    {{range $k,$v := Stored.foreignKeys}} {{end}}
    {{"Source"|T}}({{"当前表字段"|T}}) {{"Target"|T}}({{"关联字段"|T}}) {{"ON DELETE"|T}} {{"ON UPDATE"|T}}
    {{range $i, $r := $v.Source}} {{if gt $i 0}}, {{end}} {{$r}} {{end}} {{if $v.Database}}{{$v.Database}}.{{end}} {{$v.Table}} ( {{range $i, $r := $v.Target}} {{if gt $i 0}}, {{end}} {{$r}} {{end}} ) {{$v.OnDelete}} {{$v.OnUpdate}}
    {{end}} {{if Stored.supportTrigger}}
    {{"创建触发器"|T}}

    {{"触发器"|T}}

    {{range $k,$v := Stored.triggers}} {{end}}
    {{"Timing"|T}} {{"Event"|T}} {{"Trigger"|T}}
    {{$v.Timing.String}} {{$v.Event.String}} {{$v.Trigger.String}}
    {{end}}
    {{/Block}} {{Block "footer"}} {{Modal "__TMPL__/db/mysql/show_ddl.yaml"}} {{Super}} {{/Block}}