도서 대여 관리 app

테이블 (10)

Book (Untitled4)

  • book_id (book id) — INT — 기본 키 — NOT NULL
  • name (book name) — VARCHAR(100)
  • description (book description) — TEXT
  • category_id (category id2) — INT — 외래 키 → category.category_id — NOT NULL

Notification (Untitled10)

  • notification_id (notification id) — INT — 기본 키 — NOT NULL
  • title (noti name) — VARCHAR(255)
  • message — TEXT
  • created_at (created at) — TIMESTAMP
  • type_id (type id2) — INT — 외래 키 → Notification type.type_id — NOT NULL
  • user_id (user id2) — INT — 외래 키 → user.user_id — NOT NULL

Notification type (Untitled9)

  • type_id (type id) — INT — 기본 키 — NOT NULL
  • name (type name) — VARCHAR(100)

book like (Untitled8)

  • user_id (user id2) — INT — 외래 키 → user.user_id — NOT NULL
  • book_id (book id2) — INT — 외래 키 → Book.book_id — NOT NULL

category (Untitled5)

  • category_id (category id) — INT — 기본 키 — NOT NULL
  • category — VARCHAR(50)

hashtag (Untitled6)

  • hashtag_id (hashtag id) — INT — 기본 키 — NOT NULL
  • name (hashtag name) — VARCHAR(50)

hashtag-book (Untitled7)

  • book_id (book id2) — INT — 외래 키 → Book.book_id — NOT NULL
  • hashtag_id (hashtag id2) — INT — 외래 키 → hashtag.hashtag_id — NOT NULL

phone number (Untitled3)

  • user_id (user id) — INT — 외래 키 → user.user_id — NOT NULL
  • phone number — VARCHAR(20)

status (Untitled2)

  • user_id (user id) — INT — 외래 키 → user.user_id — NOT NULL
  • user_status (user status) — ENUM

user (Untitled)

  • user_id (user id) — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • gender — ENUM
  • user_pw (password) — VARCHAR(100)