RecBook

Tables (7)

Article (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • account_id (Key2) — Long — Foreign key → account.id — NOT NULL
  • title (Field2) — String
  • content (Field3) — String
  • like_count (Field4) — Long
  • created_date (Field5) — LocalDateTime
  • updated_date (Field6) — LocalDateTime

ArticleMedia (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • article_id (Key2) — Long — Foreign key → Article.id — NOT NULL
  • image_path (Field2) — String
  • created_date (Field3) — LocalDateTime
  • updated_date (Field4) — LocalDateTime

Reply (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • account_id (Key2) — Long — Foreign key → account.id — NOT NULL
  • article_id (Key3) — Long — Foreign key → Article.id — NOT NULL
  • content (Field3) — String
  • like_count (Field4) — Long
  • created_date (Field5) — LocalDateTime
  • updated_date (Field6) — LocalDateTime

account (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • user_name (Field2) — String
  • password (Field3) — String
  • sex (Field7) — String
  • birth (Field4) — String
  • created_date (Field5) — LocalDateTime
  • updated_date (Field6) — LocalDateTime

account_read_status (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • account_id (Key2) — Long — Foreign key → account.id — NOT NULL
  • book_id (Key3) — Long — Foreign key → book.id — NOT NULL
  • status (Field) — String

book (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • isbn (Field) — String
  • path (Field2) — String
  • summary (Field3) — String
  • country (Field4) — String
  • evaluation (Field5) — int
  • main_category (Field6) — String
  • price (Field7) — int
  • publish_date (Field8) — String
  • publisher (Field9) — String
  • sub_category (Field10) — String
  • title (Field11) — String
  • writer (Field12) — String

like (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • account_id (Key2) — Long — Foreign key → account.id — NOT NULL
  • article_id (Key3) — Long — Foreign key → Article.id — NOT NULL