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
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
location_id | integer | NO | Null |
location_name | character varying | YES | Null |
dept_id | integer | YES | Null |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
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 |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
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_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 |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
user_to_id | integer | NO | Null |
user_from_id | integer | NO | Null |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
dept_id | integer | NO | Null |
dept_name | character varying | YES | Null |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
take_id | integer | NO | Null |
user_id | integer | NO | Null |
字段名称 | 数据类型 | 是否可空 | 默认值 |
---|---|---|---|
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 |