carrot

Tables (5)

Like (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • USER_ID (Key2) — Long — Foreign key → User.id — NOT NULL
  • POST_ID (Key3) — Long — Foreign key → Post.USER_ID — NOT NULL

Message (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • ROOM_ID (Key2) — Long — Foreign key → Room.Key — NOT NULL
  • content (Field) — String
  • nickname (Field2) — String

Post (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • USER_ID (Key2) — Long — Foreign key → User.id — NOT NULL
  • title (Field) — String
  • category (Field2) — Enum
  • price (Field3) — int
  • area (Field4) — Enum
  • content (Field5) — String
  • imageUrl (Field6) — String
  • createdAt (Field7) — LocalDateTime
  • state (Field8) — Enum

Room (Untitled4)

  • Key — Long — Primary key — NOT NULL
  • SELLER_ID (Key2) — Long — Foreign key → User.id — NOT NULL
  • BUYER_ID (Key3) — Long — Foreign key → Post.id — NOT NULL
  • POST_ID (Key4) — Long — Foreign key → Post.USER_ID — NOT NULL
  • messageList (Field) — List

User (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — String
  • username (Field2) — String
  • password (Field3) — String