SecondHands
Tables (11)
Cate
- cate_id — int
- loc_code — VARCHAR(255) — NOT NULL
- detail_loc — VARCHAR(255)
addresstbl
- member_post — VARCHAR(500)
- member_addr — VARCHAR(500)
- detailed_address — VARCHAR(500)
board_like
- like_id — INT
- board_id — int
- user_id — VARCHAR(100)
- user_code — varchar(100)
chat_tbl
- chat_code — INT
- buy_code — VARCHAR(100)
- sell_code — VARCHAR(50)
- board_id — int
- board_title — VARCHAR(200)
- sell_nickname — VARCHAR(100)
- buy_nickname — VARCHAR(100)
- board_price — VARCHAR(10)
- board_img — VARCHAR(500)
heat_tbl
- heat_code — INT
- user_code — INT — NOT NULL
- user_heat — DECIMAL(4, 1) — NOT NULL
- heat_date — DATETIME — NOT NULL
- check_heat — VARCHAR(10)
- board_id — INT
kakaousertbl
- id — VARCHAR(50)
- nickname — VARCHAR(20)
- profile_image — VARCHAR(500)
order_tbl
- order_code — INT
- user_code — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- user_nickname — VARCHAR(100) — NOT NULL
- phone_num — VARCHAR(30) — NOT NULL
- board_id — int
- board_title — VARCHAR(200) — NOT NULL
- board_price — INT — NOT NULL
- member_post — VARCHAR(500) — NOT NULL
- member_addr — VARCHAR(500) — NOT NULL
- detailed_address — VARCHAR(500) — NOT NULL
- delivery_req — VARCHAR(100) — NOT NULL
- order_date — DATE — NOT NULL
- sell_code — VARCHAR(50)
qna_board
- q_code — INT
- q_id — VARCHAR(50) — NOT NULL
- q_title — VARCHAR(100) — NOT NULL
- q_contents — VARCHAR(1000) — NOT NULL
- q_date — DATE — NOT NULL
- q_time — TIME — NOT NULL
- q_check — VARCHAR(10) — NOT NULL
- q_writer — VARCHAR(50) — NOT NULL
qna_comment
- q_code_co — INT
- q_code — VARCHAR(100) — NOT NULL
- q_id — VARCHAR(50) — NOT NULL
- q_comment — VARCHAR(500) — NOT NULL — ARCHAR(500) NOT NUL
- q_date — DATE — NOT NULL
- q_time — TIME — NOT NULL
- q_writer — VARCHAR(50) — NOT NULL
user_board
- board_id — INT
- board_date — DATETIME — NOT NULL
- board_title — VARCHAR(200) — NOT NULL
- board_price — INT — NOT NULL
- board_text — VARCHAR(500) — NOT NULL
- board_img — VARCHAR(500) — NOT NULL
- board_likes — INT — NOT NULL
- board_soldout — INT — NOT NULL
- board_click — INT — NOT NULL
- loc_code — VARCHAR(255) — NOT NULL
- detail_loc — VARCHAR(255)
- user_code — VARCHAR(100)
- user_nickname — VARCHAR(100)
- board_cate — VARCHAR(20)
user_tbl
- user_code — INT
- user_kakao — VARCHAR(100)
- user_id — VARCHAR(100)
- user_pw — VARCHAR(100) — NOT NULL
- address — VARCHAR(500) — NOT NULL
- phone_num — VARCHAR(30) — NOT NULL
- member_post — VARCHAR(500) — NOT NULL
- member_addr — VARCHAR(500) — NOT NULL
- detailed_address — VARCHAR(500) — NOT NULL
- user_birth — VARCHAR(100) — NOT NULL
- user_nickname — VARCHAR(100) — NOT NULL
- user_image — VARCHAR(500)
- user_heat — VARCHAR(50) — NOT NULL