2020.코딩일지

다이어그램 테이블구조그리기 본문

WebServer&DB&CTI

다이어그램 테이블구조그리기

개발하는라푼젤 2022. 12. 6. 17:08
728x90

https://dbdiagram.io/

 

dbdiagram.io - Database Relationship Diagrams Design Tool

 

dbdiagram.io

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
}
Comments