은행방문예약시스템

테이블 (5)

Bank (Untitled4)

  • BankId (bankid) — varchar(45) — 기본 키 — NOT NULL
  • UserId (user_id) — varchar(45) — 외래 키 → User.UserId — NOT NULL
  • BankName (bname) — varchar(45)
  • account — varchar(45)

Reserve (Untitled2)

  • ReserveNumver (res_no) — INT(11) — 기본 키 — NOT NULL
  • BankId (bankid) — varchar(45) — 외래 키 → Bank.BankId — NOT NULL
  • UserId (user_id) — varchar(45) — 외래 키 → Bank.UserId — NOT NULL
  • ReserveDay (day) — TIMESTAMP
  • ReserveTime (time) — TIMESTAMP
  • Part (part) — varchar(45)
  • BankName (bname) — varchar(45)
  • siname — varchar(45)
  • SCode (scode) — varchar(45)
  • Gugunname (gname) — varchar(45)
  • Guguncode (gcode) — varchar(45)
  • Dongname (dname) — varchar(45)
  • Dongcode (dcode) — varchar(45)
  • IsPermit (isPermit) — boolean

User (Untitled)

  • UserId (user_id) — varchar(45) — 기본 키 — NOT NULL
  • UserPassword (user_pw) — varchar(45)
  • UserName (name) — varchar(45)
  • Email (email) — varchar(45)
  • Phone (phone) — varchar(45)
  • IsManager (isManager) — boolean

WaitingList (Untitled3)

  • ReserveNumver (res_no) — INT(11) — 외래 키 → Reserve.ReserveNumver — NOT NULL
  • UserName (name) — varchar(45)
  • Phone (phone) — varchar(45)
  • Part (part) — varchar(45)
  • WaitTime (wtime) — TIMESTAMP
  • isReserve — boolean
  • BankId (bankid) — varchar(45) — 외래 키 → Reserve.BankId — NOT NULL
  • UserId (user_id) — varchar(45) — 외래 키 → Reserve.UserId — NOT NULL

공지사항 (Untitled5)

  • NoticeId (notice_id) — varchar(45) — 기본 키 — NOT NULL
  • UserId (user_id) — varchar(45) — 외래 키 → User.UserId — NOT NULL
  • Title (title) — varchar(45)
  • Manager_id (m_id) — varchar(45)
  • PeopleNumber (p_numbers) — INT(11)
  • Day (day) — TIMESTAMP
  • Text (text) — varchar(200)