AIVLE_MINI_4th
Tables (4)
Book (책)
- Book_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- title (Field) — character varying — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
- viewCount (Field4) — Integer — NOT NULL
- category (Field5) — character varying — NOT NULL
- cover_image_url (Field6) — character varying — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → User.user_id — NOT NULL
Book_detail (상세정보)
- Book_id (Key2) — BIGINT — Foreign key → Book.Book_id — NOT NULL
- content (Field) — character large object — NOT NULL
- description (Field2) — character large object — NOT NULL
Like (Untitled)
- Like_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- Book_id (Key3) — BIGINT — Foreign key → Book.Book_id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
User (독자)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- nickname (Field) — character varying — NOT NULL
- email (Field2) — character varying — NOT NULL
- profile_image (Field3) — character varying
- create_at (Field4) — timestamp — NOT NULL