UsedLion
Tables (9)
chat
- id — INT — Primary key
- post_id — INT — NOT NULL
- sender_id — INT — NOT NULL
- content — VARCHAR(512) — NOT NULL
- created_at — TIMESTAMP
cities
- id — INT — Primary key
- city — VARCHAR(10) — NOT NULL
post
- id — INT — Primary key
- profileId — INT — NOT NULL
- view — INT
- file — BLOB
- title — VARCHAR(30)
- price — INT
- content — VARCHAR(512)
- date — TIMESTAMP
- complete — TINYINT(1)
profile
- id — INT — Primary key
- userInformationId — INT — NOT NULL
- cityId — INT — NOT NULL
reply
- id — INT — Primary key
- profileId — INT — NOT NULL
- postId — INT — NOT NULL
- content — VARCHAR(100)
- date — TIMESTAMP
report
- id — INT — Primary key
- profileId — INT — NOT NULL
- targetId — INT — NOT NULL
- content — VARCHAR(100)
user_post_like
- id — INT — Primary key
- profileId — INT — NOT NULL
- postId — INT — NOT NULL
user_transaction
- id — INT — Primary key
- sellerId — INT — NOT NULL
- buyerId — INT — NOT NULL
- postId — INT — NOT NULL
- date — TIMESTAMP
userinformation
- id — INT — Primary key
- userid — VARCHAR(20) — NOT NULL
- passwd — BINARY(32) — NOT NULL