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)