도서점
테이블 (12)
ADMIN
- admin_id — VARCHAR(20)
- admin_pw — VARCHAR(100) — NOT NULL
- admin_name — VARCHAR(50) — NOT NULL
- role — VARCHAR(10)
- regDate — TIMESTAMP
BASKET
- basket_id — INT
- u_reg_num — INT — 외래 키 → USER_REGISTRATION.user_reg_num — NOT NULL
- sale_id — INT — 외래 키 → PRODUCT_SALE.sale_id — NOT NULL
- quantity — INT
- reg_date — TIMESTAMP
BOOK
- id — INT
- title — VARCHAR(255) — NOT NULL
- writer — VARCHAR(100) — NOT NULL
- publisher — VARCHAR(100)
- pubDate — DATE
- genre — VARCHAR(50)
- language — VARCHAR(20)
- isbn — VARCHAR(50)
- image — VARCHAR(500)
PRODUCT_SALE
- sale_id — INT
- stock_id — INT — 외래 키 → STOCK_IN.stock_id — NOT NULL
- v_reg_num — INT — 외래 키 → VENDOR_REGISTRATION.vendor_reg_num — NOT NULL
- price — INT — NOT NULL
- stock_qty — INT
- sale_status — VARCHAR(10)
- regDate — TIMESTAMP
PURCHASE
- purchase_id — INT
- u_reg_num — INT — 외래 키 → USER_REGISTRATION.user_reg_num — NOT NULL
- receiver_name — VARCHAR(50) — NOT NULL
- receiver_phone — VARCHAR(20) — NOT NULL
- receiver_addr — VARCHAR(500) — NOT NULL
- total_price — INT — NOT NULL
- points_used — INT
- purchase_date — TIMESTAMP
PURCHASE_DETAIL
- detail_id — INT
- purchase_id — INT — 외래 키 → PURCHASE.purchase_id — NOT NULL
- sale_id — INT — 외래 키 → PRODUCT_SALE.sale_id — NOT NULL
- v_reg_num — INT — 외래 키 → VENDOR_REGISTRATION.vendor_reg_num — NOT NULL
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
- tracking_no — VARCHAR(50)
- delivery_status — VARCHAR(20)
QNA_CHAT
- chatId — INT
- sender_id — VARCHAR(100)
- receiver_id — VARCHAR(100)
- message — TEXT
- send_time — TIMESTAMP
QNA_MAIL
- id — INT
- title — VARCHAR(255) — NOT NULL
- u_reg_num — INT — 외래 키 → USER_REGISTRATION.user_reg_num — NOT NULL
- target_role — VARCHAR(10)
- detail — TEXT
- answer — TEXT
- reg_date — TIMESTAMP
STOCK_IN
- stock_id — INT
- v_reg_num — INT — 외래 키 → VENDOR_REGISTRATION.vendor_reg_num — NOT NULL
- book_id — INT — 외래 키 → BOOK.id — NOT NULL
- qty — INT — NOT NULL
- cost — INT — NOT NULL
- regDate — TIMESTAMP
USER_REGISTRATION
- user_reg_num — INT
- user_id — VARCHAR(100) — NOT NULL
- reg_status — VARCHAR(20)
- regDate — TIMESTAMP
VENDOR
- vendor_id — VARCHAR(20)
- vendor_pw — VARCHAR(100) — NOT NULL
- biz_name — VARCHAR(100) — NOT NULL
- biz_no — VARCHAR(20)
- contact — VARCHAR(20)
- regDate — TIMESTAMP
VENDOR_REGISTRATION
- vendor_reg_num — INT
- vendor_id — VARCHAR(20) — 외래 키 → VENDOR.vendor_id — NOT NULL
- admin_id — VARCHAR(20) — 외래 키 → ADMIN.admin_id
- is_active — TINYINT(1)
- regDate — TIMESTAMP