자린이 독서실
테이블 (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