IceClean_table
Tables (5)
Customer (점주 및 사용자)
- res_no (pk) — int — Primary key — NOT NULL
- email (이메일) — text — Primary key — NOT NULL
- name (이름) — text
- phone (연락처) — text
- addr (주소) — text
- password (비밀번호) — text
- state (상태) — int
bank (은행)
- code (은행코드) — int — Primary key — NOT NULL
- bank (은행명) — text
member (임직원)
- idx (인덱스) — text — Primary key — NOT NULL
- id (아이디) — text — Primary key — NOT NULL
- pw (비밀번호) — text
- addr (주소) — text
- mail (이메일) — text
- tel (연락처) — text
- type (유형) — int
- auth (권한) — int
- account_num (계좌번호) — int
- code (은행코드) — int — Foreign key → bank.code — NOT NULL
- indentify (승인여부) — boolean
- entr_date (입사일) — date
- file_url (프로필 사진) — text
- alarm_yn (알람여부) — boolean
- endpoint (엔드포인트) — text
- p256dh (인증토큰) — text
- alarm_auth (키값) — text
push_subscribe (알림구독)
- id (Key) — Primary key — NOT NULL
- phone (이메일) — text — Foreign key → Customer.email — NOT NULL
- phone (아이디) — text — Foreign key → member.id — NOT NULL