toonner

Tables (9)

Like (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.Key — NOT NULL
  • like_type (Field) — varchar
  • like_type_id (Field2) — BIGINT
  • Field3

bookmark (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.Key — NOT NULL
  • bookmark_type (Field) — varchar
  • bookmark_type_id (Field2) — BIGINT
  • Field3

chat (Untitled10)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • chatroom_id (Key2) — BIGINT — Foreign key → chatroom.id — NOT NULL
  • member_id (Key3) — BIGINT — Foreign key → member.Key — NOT NULL
  • contexts (Field) — varchar
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime
  • deletedAt (Field4) — datetime
  • Field5

chatroom (Untitled8)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • toon_data_id (Key2) — BIGINT — Foreign key → toon data.id — NOT NULL
  • toon_name (Field) — varchar
  • toon_imange (Field2) — varchar
  • toon_url (Field3) — varchar
  • rating_total_point (Field5) — float
  • rating_counts (Field6) — BIGINT
  • contexts (Field4) — varchar
  • fire_total_counts (Field7) — BIGINT
  • fire_today_counts (Field8) — BIGINT
  • Field9

child_feed (Untitled9)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • feed_id (Key2) — BIGINT — Foreign key → feed.id — NOT NULL
  • title (Field) — varchar
  • image_url (Field2) — varchar
  • site_url (Field7) — varchar
  • days (Field3) — JSON
  • starring (Field4) — float
  • hashtag_genre (Field5) — JSON
  • hashtag_vibe (Field6) — JSON
  • Field8

feed (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.Key — NOT NULL
  • title (Field) — varchar
  • contexts (Field2) — varchar
  • rating (Field6) — float
  • hashtag_genre (Field7) — JSON
  • hashtag_vibe (Field8) — JSON
  • createdAt (Field3) — datetime
  • updatedAt (Field4) — datetime
  • deletedAt (Field5) — datetime
  • like_counts (Field9) — BIGINT
  • Field11

fire (Untitled11)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.Key — NOT NULL
  • chatroom_id (Field) — BIGINT
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime
  • Field4

member (Untitled)

  • Key — BIGINT — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • description (Field4) — varchar
  • image (Field5) — varchar
  • keywords (Field6) — JSON
  • role (Field7) — varchar
  • favorite_toons (Field8) — JSON
  • watching_toons (Field9) — JSON
  • Field10

toon data (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • toon_name (Field) — varchar
  • contexts (Field2) — varchar
  • toon_image (Field3) — varchar
  • toon_url (Field4) — varchar
  • update_day (Field8) — JSON
  • fan_counts (Field9) — BIGINT
  • Field10