govtech
Tables (4)
Member (member)
- user_id (유저아이디) — Not Null — Primary key — NOT NULL
- password (비밀번호) — Not Null
- name (이름) — Not Null
Phone_Analyze (Untitled2)
- examine_id (검사 아이디) — @GeneratedValue — Primary key — NOT NULL
- user_id (유저아이디) — Not Null — Foreign key → Member.user_id — NOT NULL
- receipt_number (수신번호) — Not Null — Foreign key → Phonenumber.receipt_number — NOT NULL
- spam (스팸) — Not Null
- time (검사 시간) — Not Null
- report (신고 여부) — Not Null
- block (차단 여부) — Not Null
- url (주소) — Not Null
- call_message (전화/문자) — Not Null
Phonenumber (phonenumber)
- receipt_number (수신번호) — Not Null — Primary key — NOT NULL
- spam_count (스팸 신고 횟수) — Not Null
QR_Analyze (Untitled)
- qr_examine_id (qr검사 아이디) — @GeneratedValue — Primary key — NOT NULL
- user_id (유저아이디) — Not Null — Foreign key → Member.user_id — NOT NULL
- qr_spam (스팸 확인) — Not Null
- time (검사 시간) — Not Null
- url (주소)