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