secondarybook

Tables (24)

address_info

  • addr_seq — BIGINT
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • addr_nm — VARCHAR(100)
  • post_no — VARCHAR(10)
  • addr_h — VARCHAR(200)
  • addr_d — VARCHAR(200)
  • default_yn — SMALLINT

admin

  • admin_seq — BIGINT
  • admin_login_id — VARCHAR(100) — NOT NULL
  • admin_password — VARCHAR(255) — NOT NULL

admin_account

  • account_seq — BIGINT
  • balance — BIGINT
  • crt_dtm — TIMESTAMP
  • upd_dtm — TIMESTAMP

admin_account_log

  • log_seq — BIGINT
  • account_seq — BIGINT — Foreign key → admin_account.account_seq — NOT NULL
  • settlement_seq — BIGINT
  • amount — BIGINT
  • balance_after — BIGINT
  • description — VARCHAR(500)
  • crt_dtm — TIMESTAMP

banner

  • banner_seq — BIGINT
  • title — VARCHAR(200)
  • subtitle — VARCHAR(200)
  • bg_color_from — VARCHAR(20)
  • bg_color_to — VARCHAR(20)
  • btn_text — VARCHAR(100)
  • btn_link — VARCHAR(500)
  • icon_name — VARCHAR(100)
  • order_idx — INT
  • is_active — TINYINT(1)
  • crt_dtm — TIMESTAMP

book_club

  • book_club_seq — BIGINT
  • book_club_leader_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • book_club_name — VARCHAR(100) — NOT NULL
  • book_club_desc — TEXT
  • book_club_rg — VARCHAR(100)
  • book_club_max_member — INT
  • banner_img_url — VARCHAR(500)
  • book_club_schedule — VARCHAR(200)
  • crt_dtm — TIMESTAMP
  • upd_dtm — TIMESTAMP
  • book_club_deleted_dt — TIMESTAMP

book_club_board

  • book_club_board_seq — BIGINT
  • book_club_seq — BIGINT — Foreign key → book_club.book_club_seq — NOT NULL
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • parent_book_club_board_seq — BIGINT — Foreign key → book_club_board.book_club_board_seq
  • board_title — VARCHAR(200)
  • board_cont — TEXT
  • board_img_url — VARCHAR(500)
  • isbn — VARCHAR(20)
  • book_title — VARCHAR(255)
  • book_author — VARCHAR(255)
  • book_img_url — VARCHAR(500)
  • board_deleted_dtm — TIMESTAMP
  • crt_dtm — TIMESTAMP
  • upd_dtm — TIMESTAMP

book_club_board_like

  • like_seq — BIGINT
  • book_club_board_seq — BIGINT — Foreign key → book_club_board.book_club_board_seq — NOT NULL
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • crt_dtm — TIMESTAMP

book_club_member

  • book_club_member_seq — BIGINT
  • book_club_seq — BIGINT — Foreign key → book_club.book_club_seq — NOT NULL
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • leader_yn — TINYINT(1)
  • join_st — ENUM('WAIT', 'JOINED', 'REJECTED', 'LEFT', 'KICKED')
  • join_st_update_dtm — TIMESTAMP

book_club_request

  • book_club_request_seq — BIGINT
  • book_club_seq — BIGINT — Foreign key → book_club.book_club_seq — NOT NULL
  • request_member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • request_cont — TEXT
  • request_st — ENUM('WAIT', 'APPROVED', 'REJECTED')
  • request_dtm — TIMESTAMP
  • request_processed_dt — DATE

book_club_wish

  • book_club_wish_seq — BIGINT
  • book_club_seq — BIGINT — Foreign key → book_club.book_club_seq — NOT NULL
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • crt_dtm — TIMESTAMP

book_image

  • book_img_seq — BIGINT
  • trade_seq — BIGINT — Foreign key → sb_trade_info.trade_seq — NOT NULL
  • img_url — VARCHAR(500)
  • sort_seq — BIGINT

category

  • category_seq — BIGINT
  • category_nm — VARCHAR(100) — NOT NULL

chat_msg

  • chat_msg_seq — BIGINT
  • chat_room_seq — BIGINT — Foreign key → chatroom.chat_room_seq — NOT NULL
  • sender_seq — BIGINT — NOT NULL
  • chat_cont — TEXT
  • sent_dtm — TIMESTAMP
  • read_yn — TINYINT(1)

chatroom

  • chat_room_seq — BIGINT
  • trade_seq — BIGINT — Foreign key → sb_trade_info.trade_seq — NOT NULL
  • member_buyer_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • member_seller_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • last_msg — TEXT
  • last_msg_dtm — TIMESTAMP
  • crt_dtm — TIMESTAMP

login_info

  • login_info_seq — BIGINT
  • admin_seq — BIGINT — Foreign key → admin.admin_seq
  • member_seq — BIGINT — Foreign key → member_info.member_seq
  • login_dtm — TIMESTAMP
  • login_ip — VARCHAR(45)
  • logout_dtm — TIMESTAMP
  • logout_ip — VARCHAR(45)

member_bank_account

  • bank_account_seq — BIGINT
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • bank_account_no — VARCHAR(100) — NOT NULL
  • account_holder_nm — VARCHAR(50) — NOT NULL
  • verified_yn — TINYINT(1)
  • crt_dtm — TIMESTAMP
  • upd_dtm — TIMESTAMP

member_info

  • member_seq — BIGINT
  • login_id — VARCHAR(100) — NOT NULL
  • member_pwd — VARCHAR(255) — NOT NULL
  • member_email — VARCHAR(255)
  • member_tel_no — VARCHAR(20)
  • member_nicknm — VARCHAR(50)
  • member_deleted_dtm — TIMESTAMP
  • member_last_login_dtm — TIMESTAMP
  • member_st — ENUM('JOIN', 'BAN') — NOT NULL
  • crt_dtm — TIMESTAMP — NOT NULL
  • upd_dtm — TIMESTAMP

member_oauth

  • member_oauth_seq — BIGINT
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • provider — ENUM('KAKAO', 'NAVER') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • connected_dt — DATE

notice

  • notice_seq — BIGINT
  • admin_seq — BIGINT — Foreign key → admin.admin_seq
  • notice_title — VARCHAR(200)
  • notice_cont — TEXT
  • notice_priority — INT
  • active — TINYINT(1)
  • view_count — INT
  • crt_dtm — TIMESTAMP
  • upd_dtm — TIMESTAMP

sb_trade_info

  • trade_seq — BIGINT
  • member_seller_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • member_buyer_seq — BIGINT — Foreign key → member_info.member_seq
  • category_seq — BIGINT — Foreign key → category.category_seq
  • sale_title — VARCHAR(200) — NOT NULL
  • book_st — ENUM('NEW', 'LIKE_NEW', 'GOOD', 'USED')
  • sale_cont — TEXT
  • sale_price — INT
  • delivery_cost — INT
  • sale_rg — VARCHAR(100)
  • sale_st — ENUM('SALE', 'RESERVED', 'SOLD')
  • sale_st_dtm — TIMESTAMP
  • views — BIGINT
  • book_sale_dtm — TIMESTAMP
  • post_no — VARCHAR(10)
  • addr_h — VARCHAR(200)
  • addr_d — VARCHAR(200)
  • crt_dtm — TIMESTAMP — NOT NULL
  • upd_dtm — TIMESTAMP
  • del_dtm — TIMESTAMP
  • payment_type — ENUM('account', 'tosspay')
  • category_nm — VARCHAR(100)
  • isbn — VARCHAR(20)
  • book_title — VARCHAR(255)
  • book_author — VARCHAR(255)
  • book_publisher — VARCHAR(255)
  • book_img — VARCHAR(500)
  • book_org_price — INT
  • safe_payment_st — ENUM('NONE','PENDING','COMPLETED')
  • safe_payment_expire_dtm — TIMESTAMP
  • pending_buyer_seq — BIGINT
  • confirm_purchase — TINYINT(1)
  • settlement_st — ENUM('NONE','READY','REQUESTED','COMPLETED')

settlement

  • settlement_seq — BIGINT
  • trade_seq — BIGINT — Foreign key → sb_trade_info.trade_seq — NOT NULL
  • member_seller_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • sale_price — INT
  • delivery_cost — INT
  • commission_rate — DECIMAL(5,4)
  • commission — INT
  • settlement_amount — INT
  • settlement_st — ENUM('REQUESTED','COMPLETED')
  • request_dtm — TIMESTAMP
  • settled_dtm — TIMESTAMP

temp_page

  • page_seq — BIGINT
  • title — VARCHAR(200)
  • content — TEXT
  • crt_dtm — TIMESTAMP

trade_wish

  • trade_wish_seq — BIGINT
  • trade_seq — BIGINT — Foreign key → sb_trade_info.trade_seq — NOT NULL
  • member_seq — BIGINT — Foreign key → member_info.member_seq — NOT NULL
  • crt_dtm — TIMESTAMP