B-Assignment
Tables (10)
announcement (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- content (Field3) — String
- title (Field4) — varchar(32)
- notification_setting_id (Key2) — bigint — Foreign key → notify_setting.id — NOT NULL
- user_id (id) — bigint — Foreign key → notify_setting.user_id — NOT NULL
book (Untitled2)
- id (Field5) — bigint — Primary key
- category_id (Key) — bigint — Foreign key → category.id — NOT NULL
- title (Field) — varchar(64)
- description (Field2) — varchar(128)
- created_at (Field3) — datetime(6)
- updated_at (Field6) — datetime(6)
book_likes (Untitled10)
- id (Key) — bigint — Primary key — NOT NULL
- book_id (Field5) — bigint — Foreign key → book.id
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
book_tag (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- book_id (Field5) — bigint — Foreign key → book.id
- tag_id (Key2) — bigint — Foreign key → tag.id — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
category (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(24)
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
marketing (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- content (Field3) — String
- title (Field4) — varchar(32)
- notification_setting_id (Key2) — bigint — Foreign key → notify_setting.id — NOT NULL
- user_id (id) — bigint — Foreign key → notify_setting.user_id — NOT NULL
notify_setting (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
- set_announcement (Field) — boolean
- set_marketing (Field2) — boolean
- set_book_return (Field5) — boolean
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
rent (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
- book_id (Field5) — bigint — Foreign key → book.id
- when_rent (Field2) — datetime(6)
- when_return (Field) — datetime(6)
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
tag (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(24)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
user (Untitled)
- id — bigint — Primary key — NOT NULL
- name (Field) — varchar(30)
- nickname (Field2) — varchar(16)
- phone (Field3) — varchar(16)
- gender (Field4) — int
- status (Field5) — varchar(16)
- inactive_date (Field6) — datetime
- created_at (Field7) — datetime(6)
- updated_at (Field8) — datetime(6)