급여 선지급 테이블
테이블 (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)