도서 대여 관리 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)