Commento
Tables (5)
cm_book
- bk_no — int(11) — Primary key — NOT NULL
- mb_no — int(11) — Foreign key → cm_member.mb_no — NOT NULL — default value
- bk_name — varchar(100) — NOT NULL
- bk_writer — varchar(10) — NOT NULL
- bk_picture — varchar(255) — NOT NULL
- bk_content — text — NOT NULL
- bk_publish_company — varchar(45) — NOT NULL
- bk_publish_date — varchar(10) — NOT NULL
- bk_created_at — timestamp — NOT NULL
- bk_updated_at — timestamp — NOT NULL
- status — varchar(20) — NOT NULL
cm_member
- mb_no — int(11) — Primary key — NOT NULL — default value
- mb_name — varchar(45)
- mb_email — varchar(255)
- mb_password — varchar(200)
- mb_nickname — varchar(45)
- mb_picture (mb_ picture) — varchar(255)
- status — varchar(20) — NOT NULL — ‘normal’ ‘withdraw’
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
cm_oauth_detail
- mb_no — int(11) — Foreign key → cm_member.mb_no — NOT NULL — default value
- access_token — varchar(255)
- refresh_token — varchar(255)
- email — varchar(255)
- expire_time — date
- display_name — varchar(255)
- profile_url — varchar(255)
- provider — varchar(255)
- provader_id — varchar(255) — NOT NULL
cm_reply
- rp_no — int(11) — Primary key — NOT NULL
- bk_no — int(11) — Foreign key → cm_book.bk_no — NOT NULL
- mb_no (rp_writer) — int(11) — Foreign key → cm_member.mb_no — NOT NULL — default value
- rp_content — text — NOT NULL
- rp_rate — int(10) — NOT NULL
- rp_created_at — timestamp — NOT NULL
- rp_updated_at — timestamp — NOT NULL
- status — varchar(20) — NOT NULL
cm_washlist
- ws_no — int(11) — Primary key — NOT NULL
- mb_no — int(11) — Foreign key → cm_member.mb_no — NOT NULL — default value
- bk_no (ws_book) — int(11) — Foreign key → cm_book.bk_no — NOT NULL
- ws_created_at — timestamp — NOT NULL
- ws_updated_at — timestamp — NOT NULL
- status — varchar(20) — NOT NULL