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