UMC_5th-1week
Tables (7)
b_category (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — archer(20)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
book (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- b_category_id (Key2) — bigint — Foreign key → b_category.id — NOT NULL
- name (Field) — vachar(40)
- dcirp (Field3) — text
- likes (Field4) — int
- author (Field2) — vachar(40)
book_hashtag (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- hashtag_id (Key2) — bigint — Foreign key → hashtag.id — NOT NULL
- book_id (Key3) — bigint — Foreign key → book.id — NOT NULL
- b_category_id (Key22) — bigint — Foreign key → book.b_category_id — NOT NULL
book_likes (Untitled6)
- id (Key) — Primary key — NOT NULL
- book_id (Key2) — bigint — Foreign key → book.id — NOT NULL
- b_category_id (Key22) — bigint — Foreign key → book.b_category_id — NOT NULL
- user_id (Key3) — bigint — Foreign key → user.id — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
hashtag (Untitled5)
- id (Key) — Primary key — NOT NULL
- name (Field)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
rent (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- book_id (Key2) — bigint — Foreign key → book.id — NOT NULL
- user_id (Key3) — bigint — Foreign key → user.id — NOT NULL
- b_category_id (Key22) — bigint — Foreign key → book.b_category_id — NOT NULL
- created_at (Field2) — bigint
- updated_at (Field) — datetime(6)
user (\)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- Nick (Field2) — varchar(20)
- phone (Field3) — varchar(20)
- gender (Field4) — varchar(10)
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
- status (Field7) — varcher(15)
- inactive _date (Field8) — datetime