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