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)