sky-kongkong-2

Tables (5)

report

  • report_id — bigint — Primary key
  • is_solved — boolean
  • created_date_time — timestamp(6) — NOT NULL
  • updated_date_time — timestamp(6) — NOT NULL
  • detail — varchar(255)
  • category — enum
  • user_id (user_id2) — bigint — Foreign key → users.user_id

seat

  • seat_id — integer — Primary key — NOT NULL
  • is_active — boolean
  • created_date_time — timestamp(6) — NOT NULL
  • updated_date_time — timestamp(6) — NOT NULL

usage (CopyOfseat)

  • usage_id — bigint — Primary key
  • is_active — boolean
  • seat_id — integer
  • check_in — timestamp(6)
  • check_out — timestamp(6)
  • use_minutes — varbinary(255)
  • created_date_time — timestamp(6) — NOT NULL
  • updated_date_time — timestamp(6) — NOT NULL
  • user_id — bigint — Foreign key → users.user_id

user_time

  • user_time_id — bigint — Primary key
  • remain_minutes — integer
  • created_date_time — timestamp(6) — NOT NULL
  • updated_date_time — timestamp(6) — NOT NULL
  • user_id (user_id2) — bigint — Foreign key → users.user_id

users

  • user_id — bigint — Primary key
  • created_date_time — timestamp(6) — NOT NULL
  • updated_date_time — timestamp(6) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL