급여 선지급 테이블

테이블 (7)

board (Untitled4)

  • board_seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • role (Field4)
  • title (Field2)
  • content (Field)
  • regdate (Field5)
  • delflag (Field6)

fintech (Untitled3)

  • account_seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • account (Field2)
  • fintech_use_num (Field)
  • bank_name (Field3)
  • account_num_masked (Field4)
  • money (Field5)

firstpayboard (Untitled5)

  • board_seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • NAME (Field2)
  • role (Field3)
  • regdate (Field4)
  • money (Field5)
  • delflag (Field6)

memberid (Untitled)

  • memberid (Key) — 기본 키 — NOT NULL
  • id (Key2) — 기본 키 — NOT NULL
  • PASSWORD (Field)
  • NAME (Field2)
  • address (Field3)
  • email (Field4)
  • ROLE (Field6)
  • USERACCESSTOKEN (Field7)
  • USERREFRESHTOKEN (Field8)
  • USERSEQNO (Field9)
  • phone (Field10)
  • pay (Field11)

month_schedule (Untitled7)

  • seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • NAME (Field2)
  • role (Field3)
  • content (Field4)
  • mdate (Field5)
  • sdate (Field6)
  • edate (Field7)
  • work_hours (Field8)

schedule (Untitled6)

  • seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • NAME (Field2)
  • role (Field3)
  • content (Field4)
  • mdate (Field5)
  • sdate (Field6)
  • edate (Field7)
  • work_hours (Field8)

userfile (Untitled2)

  • file_seq (Key) — 기본 키 — NOT NULL
  • memberid (Key2) — 외래 키 → memberid.memberid — NOT NULL
  • id (Key22) — 외래 키 → memberid.id — NOT NULL
  • origin_filename (Field2)
  • stored_filename (Field3)