seoulmilkErd(temp)

Tables (4)

Member (사용자)

  • member_id (사번) — Long — Primary key — NOT NULL
  • passward (비밀번호) — Varchar
  • role (권한) — enum

NTS_TAX (세금계산서)

  • member_id (사번) — Long — Foreign key → Member.member_id — NOT NULL

Tax_image (계산서 이미지)

  • id (Key) — Primary key — NOT NULL
  • member_id (사번) — Long — Foreign key → Member.member_id — NOT NULL
  • image_url (Field) — varchar
  • create_at (Field2) — timestamp
  • update_at (Field3) — timestamp

payment resolution (지급결의서)

  • Key — Primary key — NOT NULL
  • member_id (사번) — Long — Foreign key → Member.member_id — NOT NULL