fleamarket

Tables (6)

CHAT (Untitled4)

  • CONTENT (Field2) — TEXT
  • ROOM_ID (Key2) — INT — Foreign key → ROOM.id — NOT NULL
  • created_at (Field) — DATE

ITEMS (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • THUMBNAIL (Field) — VARCHAR(16)
  • TITLE (Field2) — VARCHAR(32)
  • PRICE (Field3) — INT
  • STATE (Field4) — INT
  • CATEGORY (Field5) — VARCHAR(16)
  • CONTENT (Field7) — TEXT
  • created_at (Field8) — DATE
  • USER_ID (Key2) — INT — Foreign key → USERS.id — NOT NULL

LIKE (Untitled6)

  • id (Key) — INT — Primary key — NOT NULL
  • ITEM_ID (Key2) — INT — Foreign key → ITEMS.id — NOT NULL
  • USER_ID (Key3) — INT — Foreign key → USERS.id — NOT NULL

PHOTOS (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • SOURCE (Field) — TEXT
  • ITEM_ID (Key2) — INT — Foreign key → ITEMS.id — NOT NULL

ROOM (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USERS.id — NOT NULL
  • ITEM_ID (Key3) — INT — Foreign key → ITEMS.id — NOT NULL

USERS (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • USER_ID (Field) — VARCHAR(32)
  • PASSWORD (Field2) — VARCHAR(32)
  • TOWN (Field3) — VARCHAR(16)
  • GITHUB_ID (Field4) — VARCHAR(32)
  • PROVIDER (Field5) — VARCHAR(32)