carrot

Tables (10)

authority (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • authority (Field)

chat_message (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • update_at (Field2)
  • message (Field3)
  • chat_room_id (Key2) — Foreign key → chat_room.id — NOT NULL
  • writer (Key3) — Foreign key → custom_user.id — NOT NULL

chat_room (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • deleted (Field)
  • post_id (Key2) — Foreign key → post.id — NOT NULL
  • buyer_id (Key3) — Foreign key → custom_user.id — NOT NULL

custom_user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • deleted (Field)
  • email (Field2)
  • password (Field3)

likes (Untitled8)

  • like_user_id (Key) — Foreign key → custom_user.id — NOT NULL
  • post_id (Key2) — Foreign key → post.id — NOT NULL

photo (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • deleted (Field)
  • thumbnail (Field2)
  • url (Field3)
  • post_id (Key2) — Foreign key → post.id — NOT NULL

post (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • update_at (Field2)
  • category (Field3)
  • contents (Field4)
  • deleted (Field5)
  • like_count (Field6)
  • owner_id (Field7)
  • point (Field8)
  • price (Field9)
  • region (Field10)
  • stock_status (Field11)
  • title (Field12)
  • user_id (Key2) — Foreign key → custom_user.id — NOT NULL

refresh_token (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • refresh_token (Field)
  • id (Key2) — Foreign key → custom_user.id — NOT NULL

user_info (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • deleted (Field)
  • name (Field2)
  • nickname (Field3)
  • phone (Field4)
  • profile_image (Field5)
  • user_id (Key2) — Foreign key → custom_user.id — NOT NULL

user_roles (Untitled4)

  • role_id (Key) — Foreign key → authority.id — NOT NULL
  • user_id (Key2) — Foreign key → custom_user.id — NOT NULL