numva

Tables (4)

memo

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL — FK references users
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL
  • usertype_id — INT — Foreign key → users.usertype_id — NOT NULL — FK references usertypes
  • memo — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

qrcode

  • id — BIGINT — Primary key — NOT NULL
  • qr_id — VARCHAR — Primary key — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_has_safety_info

  • id — BIGINT — Primary key — NOT NULL — AI
  • user_id — BIGINT — Primary key — NOT NULL
  • qr_id — BIGINT — Primary key — NOT NULL
  • sn_id — BIGINT — Primary key — NOT NULL
  • memo_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — BIGINT — Foreign key → memo.id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → memo.user_id — NOT NULL — FK references users
  • id (id22) — BIGINT — Foreign key → memo.id — NOT NULL
  • usertype_id — INT — Foreign key → memo.usertype_id — NOT NULL — FK references usertypes
  • id (id3) — BIGINT — Foreign key → users.id — NOT NULL
  • usertype_id (usertype_id2) — INT — Foreign key → users.usertype_id — NOT NULL — FK references usertypes
  • id (id4) — BIGINT — Foreign key → qrcode.id — NOT NULL
  • qr_id (qr_id2) — VARCHAR — Foreign key → qrcode.qr_id — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • usertype_id — INT — Primary key — NOT NULL — FK references usertypes
  • name — VARCHAR(16) — NOT NULL
  • email — VARCHAR(25) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • second_phone — VARCHAR(50)
  • birth — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP