Rotuerecipt

테이블 (6)

공지사항 (notie)

  • n_id (PK) — BigInt — 기본 키 — NOT NULL
  • n_title (Field) — varchar
  • n_write (Field2) — varchar
  • n_content (Field3) — varchar
  • n_create (Field4) — date

규칙 (role)

  • role_id (PK) — varchar — 기본 키 — NOT NULL
  • role_name (Field) — varchar

영수증 (receipt)

  • r_no (PK) — BigInt — 기본 키 — NOT NULL
  • r_u (FK) — varchar
  • r_place (Field) — varchar
  • r_price (Field2) — BigInt
  • r_date (Field3) — date
  • u_id (PK2) — varchar — 외래 키 → 유저.u_id — NOT NULL

유저 (user)

  • u_id (PK) — varchar — 기본 키 — NOT NULL
  • u_pw (Field) — varchar
  • u_name (Field2) — varchar
  • u_birthday (Field3) — date
  • u_email (Field4) — varchar
  • u_date (Field5) — date
  • gender (enum) — enum
  • role (FK) — varchar
  • role_id (PK2) — varchar — 외래 키 → 규칙.role_id — NOT NULL

재학습테이블 (ai_traning_item)

  • train_id (PK) — BigInt — 기본 키 — NOT NULL
  • item_text (Field) — varchar
  • predicted_label (Field2) — varchar
  • predicted_confidence (Field3) — varchar
  • ai_source (Field4) — varchar
  • model_version (Field5) — varchar
  • final_label (Field6) — varchar
  • corrected_yn (Field7) — varchar
  • used_for_training (Field8) — varchar
  • trained_at (Field9) — date
  • created_at (Field10) — date

카테고리 (receipt_item)

  • item_id (PK) — BigInt — 기본 키 — NOT NULL
  • r_no (FK) — BigInt
  • item_name (Field) — varchar
  • item_category (Field2) — varchar
  • ai_source (Field3) — varchar
  • ai_confidence (Field4) — double
  • r_no (PK2) — BigInt — 외래 키 → 영수증.r_no — NOT NULL