Hackerthon

Tables (8)

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (password) — varchar(20) — NOT NULL
  • Field2 (nickName) — varchar(20)
  • Field (gender) — varchar(10)
  • Field3 (email) — varchar(30)
  • Field (status) — char(10) — NOT NULL
  • Field4 (phone) — varchar(20)
  • Field (credit) — int — NOT NULL
  • Field5 (create_at) — datetime(6) — NOT NULL
  • Field (update_at) — datetime(6) — NOT NULL

Untitled (article)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100)
  • Field (body) — varchar(200)
  • Field (status) — CHAR(10) — NOT NULL
  • Field2 (articlePrice) — int
  • Field (create_at) — datetime(6) — NOT NULL
  • Field2 (update_at) — datetime(6) — NOT NULL

Untitled (category)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name)
  • Field (updated_at) — datetime(6) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL

Untitled (likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field2 (undate_at) — datetime(6) — NOT NULL

Untitled (chat_room)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at)

Untitled (chat_message)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (chat_room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (message) — varchar(255) — NOT NULL
  • Field (reading) — boolean — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (pay_user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL
  • Field2 (credit) — long
  • Field3
  • Field4

Untitled (bank_account)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (pay_user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (account_number) — varchar(100)
  • Field (balance) — bigint
  • Field (bank_name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)