treasure

Tables (12)

board

  • board_id — int — Primary key — NOT NULL
  • user_num — int — Foreign key → user.user_num
  • item_num — int — Foreign key → item.item_num
  • board_content — varchar(3000)
  • board_image — varchar(1000)
  • board_like_count — int
  • board_comment_count — int
  • board_writeday — datetime
  • board_subject — varchar(50)
  • name — varchar(30)
  • myid — varchar(30)
  • myphoto — varchar(1000)

board_like

  • board_like_id — int — Primary key — NOT NULL
  • board_id — int — Foreign key → board.board_id
  • user_num — int — Foreign key → user.user_num

buy_bid

  • buy_num — int — Primary key — NOT NULL
  • item_num — int — Foreign key → item.item_num
  • user_num — int — Foreign key → user.user_num
  • sell_num — int — Foreign key → sell_bid.sell_num
  • buy_wishprice — int
  • buy_size — varchar(20)
  • buy_addr — varchar(50)
  • buy_deadline — int
  • buy_inputday — datetime
  • buy_modifyday — datetime
  • buy_status — varchar(20)

buy_now

  • buynow_num — int — Primary key — NOT NULL
  • user_num — int
  • item_num — int — Foreign key → item.item_num
  • sell_num — int
  • buynow_price — int
  • buy_status — int
  • delivery — varchar(30)
  • buy_addr — varchar(100)
  • payment — varchar(30)
  • buynow_inputday — datetime

comment

  • comment_id — int — Primary key — NOT NULL
  • comment_content — varchar(1000)
  • user_num — int — Foreign key → user.user_num
  • board_id — int — Foreign key → board.board_id
  • comment_writeday — datetime

comment_like

  • comment_like_id — int — Primary key — NOT NULL
  • comment_id — int — Foreign key → comment.comment_id
  • user_num — int — Foreign key → user.user_num

item

  • item_num — int — Primary key — NOT NULL
  • item_brandname — varchar(50)
  • item_category — varchar(50)
  • item_engname — varchar(200)
  • item_korname — varchar(100)
  • item_modelnum — varchar(200)
  • item_releaseday — varchar(20)
  • item_color — varchar(100)
  • item_releaseprice — varchar(50)
  • item_image — varchar(200)
  • item_inputday — datetime

order

  • order_num — int — Primary key — NOT NULL
  • buy_user — int
  • sell_user — int
  • item_num — int — Foreign key → item.item_num
  • size — varchar(50)
  • wish_price — int
  • order_date — datetime

sell_bid

  • sell_num — int — Primary key — NOT NULL
  • user_num — int — Foreign key → user.user_num
  • item_num — int — Foreign key → item.item_num
  • sell_account — varchar(50)
  • sell_penaltypay — varchar(50)
  • sell_wishprice — int
  • sell_totalprice — int
  • sell_size — varchar(50)
  • sell_deadline — int
  • sell_inputday — datetime
  • sell_addr — varchar(500)
  • sell_status — varchar(100)
  • test_result — varchar(50)

sell_now

  • sellnow_num — int — Primary key — NOT NULL
  • user_num — int — Foreign key → user.user_num
  • item_num — int — Foreign key → item.item_num
  • buy_num — int — Foreign key → buy_bid.buy_num
  • sellnow_totalprice — int
  • sellnow_account — varchar(50)
  • sellnow_penaltypay — varchar(50)
  • sellnow_addr — varchar(200)
  • sell_status — varchar(200)
  • test_result — varchar(20)
  • sellnow_inputday — datetime

sell_total

  • selltotal_num — int — Primary key — NOT NULL
  • user_num — int — Foreign key → user.user_num
  • sell_num — int — Foreign key → sell_bid.sell_num
  • sellnow_num — int — Foreign key → sell_now.sellnow_num

user

  • user_num — int — Primary key — NOT NULL
  • user_email — varchar(100)
  • user_pass — varchar(50)
  • user_name — varchar(50)
  • user_nickname — varchar(50)
  • user_photo — varchar(100)
  • user_hp — varchar(50)
  • user_birth — date
  • user_addr — varchar(100)
  • user_joinday — datetime