도서점

테이블 (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