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