중고서적

테이블 (7)

book_image

  • book_img_seq — BIGINT
  • trade_seq — BIGINT — NOT NULL
  • img_url — VARCHAR(500) — NOT NULL
  • reg_seq — BIGINT

book_info

  • book_seq — BIGINT
  • isbn — VARCHAR(20)
  • book_title — VARCHAR(200) — NOT NULL
  • book_author — VARCHAR(100)
  • book_publisher — VARCHAR(100)
  • book_img — VARCHAR(500)
  • book_org_price — INT

category

  • category_seq — BIGINT
  • category_nm — VARCHAR(50) — NOT NULL
  • category_luse_nm — VARCHAR(100)
  • category_sort_seq — BIGINT
  • crt_dtm — TIMESTAMP — NOT NULL
  • upd_dtm — TIMESTAMP

member_info

  • member_seq — BIGINT
  • login_id — VARCHAR(50) — NOT NULL
  • member_pwd — VARCHAR(255) — NOT NULL
  • member_email — VARCHAR(100) — NOT NULL
  • member_tel_no — VARCHAR(20)
  • member_nicknm — VARCHAR(50)
  • member_deleted_dt — DATE
  • member_last_login_dtm — TIMESTAMP
  • member_st — VARCHAR(10) — NOT NULL
  • crt_dtm — TIMESTAMP — NOT NULL
  • upd_dtm — TIMESTAMP

sb_trade_info

  • trade_seq — BIGINT
  • member_seller_seq — BIGINT — NOT NULL
  • sale_title — VARCHAR(200) — NOT NULL
  • book_seq — BIGINT — NOT NULL
  • category_seq — BIGINT — NOT NULL
  • book_st — VARCHAR(20)
  • sale_cont — TEXT
  • sale_price — INT — NOT NULL
  • book_delivery_cost — INT
  • sale_region_nm — VARCHAR(100)
  • sale_st — VARCHAR(20)
  • sale_st_dtm — TIMESTAMP
  • views — BIGINT — NOT NULL
  • wish_cnt — BIGINT — NOT NULL
  • member_buyer_seq — BIGINT
  • book_sale_dtm — TIMESTAMP
  • post_no — VARCHAR(10)
  • addr_h — VARCHAR(200)
  • addr_d — VARCHAR(200)
  • recipient_ph_no — VARCHAR(20)
  • recipient_nm — VARCHAR(50)
  • crt_dtm — TIMESTAMP — NOT NULL
  • upd_dtm — TIMESTAMP
  • payment_type — VARCHAR(20)
  • settlement_seq — BIGINT

settlement

  • settlement_seq — BIGINT
  • trade_seq — BIGINT — NOT NULL
  • member_seller_id — BIGINT
  • member_buyer_id — BIGINT
  • sale_price — BIGINT
  • settlement_st — VARCHAR(20)
  • crt_dtm — TIMESTAMP — NOT NULL

trade_wish

  • trade_wish_seq — BIGINT
  • member_seq — BIGINT — NOT NULL
  • crt_dtm — TIMESTAMP — NOT NULL