2020.코딩일지
다이어그램 테이블구조그리기 본문
728x90
Table users {
id int
user_id varchar20
user_pwd varchar20
user_nick varchar20
user_pfp text
address varchar100
private_key varchar100
haes_sal_amount int
ip_amount int
crop_count int
crop_per int
created_at timestamp
}
Table rand {
id int
address varchar100
tile json
}
Table bag {
id int
address varchar100
item json
}
Table market_item {
id int
item_name varchar20
item_count varchar20
selling_price int
address varchar100
time varchar20
quality varchar10
created_at timestamp
}
Table market_nft {
id int
nft_id int
nft_name varchar30
selling_price int
address varchar100
metadata_url varchar255
img_url varchar255
created_at timestamp
}
'WebServer&DB&CTI' 카테고리의 다른 글
[에러해결]Error: You attempted to save an instance with no primary key, this is not allowed since it would result in a global update (0) | 2022.11.18 |
---|---|
[mac] postgresql Guide (0) | 2022.11.03 |
[Docker]Node.js웹 앱의 도커라이징Dockerizing(컨테이너화) (0) | 2022.08.20 |
[Docker]리눅스기반, 왜도커인가[BEB 6th] (0) | 2022.08.19 |
[인증/보안]OAuth2.0[BEB 6th] (1) | 2022.08.15 |
Comments