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