자린이 독서실

테이블 (4)

admin (Untitled3)

  • adminid (Key) — varchar2 — 기본 키 — NOT NULL
  • adminpassword — varchar2
  • adminaddress — varchar2

client (Untitled)

  • phonenumber — varchar2 — 기본 키 — NOT NULL
  • adminid (Key) — varchar2 — 외래 키 → admin.adminid — NOT NULL
  • password — varchar2
  • name — varchar2
  • address — varchar2
  • starttime (Field) — date
  • endtime (Field2) — date

pay (Untitled4)

  • paynum (Key2) — num — 기본 키 — NOT NULL
  • phonenumber — varchar2 — 외래 키 → client.phonenumber — NOT NULL
  • adminid (Key) — varchar2 — 외래 키 → client.adminid — NOT NULL
  • seatnumber — number — 외래 키 → seat.seatnumber — NOT NULL
  • adminid (Key3) — varchar2 — 외래 키 → seat.adminid — NOT NULL

seat (Untitled2)

  • seatnumber — number — 기본 키 — NOT NULL
  • adminid (Key) — varchar2 — 외래 키 → admin.adminid — NOT NULL
  • seatpartition — number
  • adminid (Field) — varchar2