/*
 * ********************************************************************************************************************
 *
 *               iFHS7.
 *              ;BBMBMBMc                  rZMBMBR              BMB
 *              MBEr:;PBM,               7MBMMEOBB:             BBB                       RBW
 *     XK:      BO     SB.     :SZ       MBM.       c;;     ir  BBM :FFr       :SSF:    ;xBMB:r   iuGXv.    i:. iF2;
 *     DBBM0r.  :D     S7   ;XMBMB       GMBMu.     MBM:   BMB  MBMBBBMBMS   WMBMBMBBK  MBMBMBM  BMBRBMBW  .MBMBMBMBB
 *      :JMRMMD  ..    ,  1MMRM1;         ;MBMBBR:   MBM  ;MB:  BMB:   MBM. RMBr   sBMH   BM0         UMB,  BMB.  KMBv
 *     ;.   XOW  B1; :uM: 1RE,   i           .2BMBs  rMB. MBO   MBO    JMB; MBB     MBM   BBS    7MBMBOBM:  MBW   :BMc
 *     OBRJ.SEE  MRDOWOR, 3DE:7OBM       .     ;BMB   RMR7BM    BMB    MBB. BMB    ,BMR  .BBZ   MMB   rMB,  BMM   rMB7
 *     :FBRO0D0  RKXSXPR. JOKOOMPi       BMBSSWBMB;    BMBB:    MBMB0ZMBMS  .BMBOXRBMB    MBMDE RBM2;SMBM;  MBB   xBM2
 *         iZGE  O0SHSPO. uGZ7.          sBMBMBDL      :BMO     OZu:BMBK,     rRBMB0;     ,EBMB  xBMBr:ER.  RDU   :OO;
 *     ,BZ, 1D0  RPSFHXR. xWZ .SMr                  . .BBB
 *      :0BMRDG  RESSSKR. 2WOMBW;                   BMBMR
 *         i0BM: SWKHKGO  MBDv
 *           .UB  OOGDM. MK,                                          Copyright (c) 2015-2020.  斯伯坦机器人
 *              ,  XMW  ..
 *                  r                                                                     All rights reserved.
 *
 * ********************************************************************************************************************
 */

package com.sybotan.service.postgresql.models

import io.swagger.annotations.ApiModel
import io.swagger.annotations.ApiModelProperty
import javax.persistence.Column
import javax.persistence.Table

/**
 * 数据库设计-表结构
 *
 * @author  庞利祥 <sybotan@126.com>
 */
@ApiModel(description = "数据库设计-表结构")
@Table(name = "information_schema.columns")
open class SColumn {
    /** 模式 */
    @ApiModelProperty(value = "模式")
    @Column(name = "table_schema")
    var schemaName: String? = null

    /** 表名 */
    @ApiModelProperty(value = "表名")
    @Column(name = "table_name")
    var tableName: String? = null

    /** 字段名 */
    @ApiModelProperty(value = "字段名")
    @Column(name = "column_name")
    var columnName: String? = null

    /** 类型 */
    @Column(name = "udt_name")
    @ApiModelProperty(value = "类型")
    var columnType: String? = null

    /** 字符最大长度 */
    @ApiModelProperty(value = "字符最大长度")
    @Column(name = "character_maximum_length")
    var charMaxLength: Int? = null

    /** 可为空 */
    @ApiModelProperty(value = "可为空")
    @Column(name = "is_nullable")
    var nullable: String? = null

    /** 默认值 */
    @ApiModelProperty(value = "默认值")
    @Column(name = "column_default")
    var default: String? = null

    /** 注释 */
    @ApiModelProperty(value = "注释")
    @Column(name = "description")
    var description: String? = null

} // Class SColumn