Final_Back
Tables (9)
QAboard
- board_no — INT — Primary key — NOT NULL
- user_no — INT — NOT NULL
- board_title — VARCHAR(50) — NOT NULL
- board_cont — VARCHAR(3000) — NOT NULL
- board_file — VARCHAR(200)
- board_hit — INT — NOT NULL
- board_date — DATETIME — NOT NULL
- board_update — DATETIME
basket
- basket_no — INT — Primary key — NOT NULL
- book_no — INT — NOT NULL
- user_no — INT — NOT NULL
- book_amount — INT — NOT NULL
- one_price — INT — NOT NULL
book
- book_no — INT — Primary key — NOT NULL
- category_no — INT — NOT NULL
- book_title — VARCHAR(100) — NOT NULL
- book_intro — VARCHAR(100) — NOT NULL
- book_price — VARCHAR(100) — NOT NULL
- book_image — VARCHAR(200) — NOT NULL
- book_author — VARCHAR(100) — NOT NULL
- book_amount — INT — NOT NULL
- ISBN — INT
category
- category_no — INT — Primary key — NOT NULL
- category — VARCHAR(100) — NOT NULL
chat
- chat_no — INT — Primary key — NOT NULL
- user_no — INT — NOT NULL
- user_no2 — INT — NOT NULL
- chat_cont — VARCHAR(2000) — NOT NULL
dibs
- dibs_no — INT — Primary key — NOT NULL
- book_no — INT — NOT NULL
- user_no — INT — NOT NULL
order
- order_no — INT — Primary key — NOT NULL
- user_no — INT — NOT NULL
- book_no — INT — NOT NULL
- order_price — INT — NOT NULL — 책 가격
- order_date — DATETIME — NOT NULL
- order_amount — INT
- order_level — INT — NOT NULL — 구매 단계
seller
- seller_no — INT — Primary key — NOT NULL
- user_no — INT — NOT NULL
- seller_title — VARCHAR(50) — NOT NULL
- seller_cont — VARCHAR(3000) — NOT NULL
- seller_file — VARCHAR(200) — 판매 물품 이미지
- seller_hit — INT — NOT NULL
- seller_date — DATETIME — NOT NULL
- seller_update — DATETIME
user
- user_no — INT — Primary key — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- user_pwd — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- user_nickname — VARCHAR(100) — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_phone — VARCHAR(100) — NOT NULL
- user_birth — DATETIME — NOT NULL
- user_approve — INT — NOT NULL — 회원 직책 구별
- user_money — INT — NOT NULL
- category_no — INT — NOT NULL — 유저 관심 카테고리1
- category_no2 — INT — NOT NULL — 유저 관심 카테고리2