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

Reservation (Untitled5)

    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