midas19th

Tables (7)

Access_Log (Untitled5)

  • access_log_sn (Key) — Long — Primary key — NOT NULL
  • user_sn (Key2) — Long — Foreign key → User.user_sn — NOT NULL

Banner (Untitled)

  • sn (BIGINT) — Long — Primary key — NOT NULL
  • contents (Field) — String
  • img_url (Field2) — String
  • open_yn (Field3) — Boolean

BasEntity (Untitled2)

  • create_datetime (Field) — LocalDateTime
  • last_modified_datetime (Field2) — LocalDateTime
  • Field3

Category (Untitled7)

  • category_sn (Key) — Long — Primary key — NOT NULL
  • type (Field) — String
  • img_url (Field2) — String

Like_User (Untitled4)

  • like_user_sn (Key) — Long — Primary key — NOT NULL
  • user_sn (Key2) — Long — Foreign key → User.user_sn — NOT NULL
  • post_sn (Key3) — Long — Foreign key → Post.post_sn — NOT NULL

Post (Untitled6)

  • post_sn (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • contents (Field2) — String
  • reference (Field3) — String
  • description (Field4) — String
  • thumbnail_url (Field5) — String
  • img_url (Field6) — String
  • youtube_url (Field7) — String
  • category_sn (Key2) — Long — Foreign key → Category.category_sn — NOT NULL
  • user_sn (Key3) — Long — Foreign key → User.user_sn — NOT NULL

User (Untitled3)

  • user_sn (Key) — Long — Primary key — NOT NULL
  • id (Field5) — String
  • password (Field) — String
  • name (Field2) — String
  • dept (Field3) — String
  • hire_date (Field4) — DateTime
  • employee_num (Field6) — Integer
  • role (Field7) — String