중고서적 2
테이블 (8)
address_info
- member_seq — BIGINT — 기본 키 — NOT NULL
- addr_seq — BIGINT — 기본 키 — NOT NULL
- post_no — VARCHAR(10)
- addr_h — VARCHAR(200)
- addr_d — VARCHAR(200)
- default_yn — CHAR(1)
- addr_nm — VARCHAR(50)
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