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