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 (주소)