umc4
Tables (9)
alarm (알람)
- pk (id) — bigint — Primary key — NOT NULL
- pk (user_Id) — bigint — Foreign key → user.pk — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- 제목 (title) — varchar(30)
- 내용 (content) — text
- 공지 종류 (type) — enum
book (책)
- pk (id) — bigint — Primary key — NOT NULL
- pk (category_id) — bigint — Foreign key → category.pk — NOT NULL
- 제목 (title) — varchar(50)
- 설명 (content) — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
book_hashtag (책 해시태그)
- pk (id) — bigint — Primary key — NOT NULL
- fk (hashtag_id) — bigint — Foreign key → hashtag.pk — NOT NULL
- fd (book_Id) — bigint — Foreign key → book.pk — NOT NULL
category (카테고리)
- pk (id) — bigint — Primary key — NOT NULL
- 카테고리 (category) — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
hashtag (해시태그)
- pk (id) — bigint — Primary key — NOT NULL
- 내용 (content) — varchar(30)
- created_at — datetime(6)
- updated_at — datetime(6)
like (좋아요)
- pk (id) — bigint — Primary key — NOT NULL
- fk (user_id) — bigint — Foreign key → user.pk — NOT NULL
- fk (book_Id) — bigint — Foreign key → book.pk — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
rent (대여)
- pk (id) — bigint — Primary key — NOT NULL
- fk (user_id) — bigint — Foreign key → user.pk — NOT NULL
- fk (book_Id) — bigint — Foreign key → book.pk — NOT NULL
- 반납 마감 시간 (last_time) — datetime
- 반납시간 (time) — datetime
- 대여시간 (created_at) — datetime(6)
- Field
table (테이블)
- pk (id) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
user (사용자)
- pk (id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar(15)
- 닉네임 (nickname) — varchar(15)
- 전화번호 (phone) — varchar(15)
- 성별 (gender) — varchar(10)
- created)at (created_at) — datetime(6)
- updated_at — datetime(6)
- 탈퇴여부 (status) — varchar(15)
- 비활성기간 (inactive_date) — datetime