은행방문예약시스템
테이블 (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)