fun4wut/table-structure-generator

A generator to show the structure of the PGSQL table in HTML

Table-Structure-Generator

Usage

table-structure-generator 1.0
Fun4wut
Generate PGSQL table structure

USAGE:
    table-structure-generator [OPTIONS] --password <PASSWORD> [TABLES]...

FLAGS:
    -h, --help       Prints help information
    -V, --version    Prints version information

OPTIONS:
    -d, --database <DATABASE>    Sets database [default: postgres]
    -H, --host <HOST>            Sets the host [default: 127.0.0.1]
    -P, --password <PASSWORD>    Sets the password
    -p, --port <PORT>            Sets the port [default: 5432]
    -U, --username <USERNAME>    Sets PG username [default: postgres]

ARGS:
    <TABLES>...    the tables you want to generate the structure, default is all tables

This will print the html to stdin .

Tips:You can use > to redirect the output to a certain file

Example Preview

location

字段名称	数据类型	是否可空	默认值
location_id	integer	NO	Null
location_name	character varying	YES	Null
dept_id	integer	YES	Null

user_info

字段名称	数据类型	是否可空	默认值
user_id	integer	NO	Null
permission	USER-DEFINED	YES	Null
score	integer	YES	Null
user_name	character varying	YES	Null
user_password	character varying	YES	Null
dept_id	integer	YES	Null
avatar	bytea	YES	Null

score_history

字段名称	数据类型	是否可空	默认值
history_id	integer	NO	Null
now_score	integer	YES	Null
prev_score	integer	YES	Null
user_id	integer	YES	Null
history_time	timestamp without time zone	YES	Null

take

字段名称	数据类型	是否可空	默认值
take_id	integer	NO	Null
take_status	USER-DEFINED	YES	Null
course_id	integer	YES	Null
take_time	timestamp without time zone	YES	Null
team_num	integer	YES	Null

friendship

字段名称	数据类型	是否可空	默认值
user_to_id	integer	NO	Null
user_from_id	integer	NO	Null

department

字段名称	数据类型	是否可空	默认值
dept_id	integer	NO	Null
dept_name	character varying	YES	Null

take_user_info

字段名称	数据类型	是否可空	默认值
take_id	integer	NO	Null
user_id	integer	NO	Null

course

字段名称	数据类型	是否可空	默认值
course_id	integer	NO	Null
capacity	integer	YES	Null
course_name	character varying	YES	Null
end_time	timestamp without time zone	YES	Null
num	integer	YES	Null
start_time	timestamp without time zone	YES	Null
visible	boolean	YES	Null
dept_id	integer	YES	Null
location_id	integer	YES	Null