project-book-publisher
Tables (4)
Book
- ID (book_id) — INT(20) — Primary key — NOT NULL
- MEMBER ID (member_id) — INT(20) — Foreign key → Member.ID — NOT NULL
- IMAGE ID (image_id) — INT(20) — Foreign key → Image.ID — NOT NULL
- TITLE (book_title) — VARCHAR(255)
- CONTENT (book_content) — VARCHAR(255)
- AUTHOR (book_author) — VARCHAR(255)
- TYPE (book_type) — 'ESSAY', 'NOVEL', 'POEM', 'STUDY'
- PUBLISH DATE (date_publish) — DATETIME(6)
- PERMITTED (is_permitted) — TINYINT(1)
EmailCode
- ID (code_id) — INT(20) — Primary key — NOT NULL
- MEMBER ID (member_id) — INT(20) — Foreign key → Member.ID — NOT NULL
- KEY (code_key) — VARCHAR(64)
- TYPE (code_type) — 'FIND', 'REGISTER'
- EXPIRED (is_expired) — TINYINT(1)
Image
- ID (image_id) — INT(20) — Primary key — NOT NULL
- UUID (image_uuid) — VARCHAR(255)
- NAME (image_name) — VARCHAR(255)
- PATH (image_pathf) — VARCHAR(255)
Member
- ID (member_id) — INT(20) — Primary key — NOT NULL
- EMAIL (member_email) — VARCHAR(255)
- PASSWORD (member_password) — VARCHAR(255)
- PHONE (member_phone) — VARCHAR(255)
- ROLE (member_role) — 'ADMIN', 'USER'
- ENABLED (is_enabled) — TINYINT(1)