sosonagi
Tables (9)
Untitled (APT)
- Key (apt_seq) — int — Primary key — NOT NULL
- Field (apt_name) — varchar2
Untitled (Room)
- Key (Room_seq) — int — Primary key — NOT NULL
- Key (apt_seq) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (room)
- Key (room_seq) — int — Primary key — NOT NULL
- Key (Room_seq) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (wall)
- Key (wall_seq) — int — Primary key — NOT NULL
- Key (room_seq) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (member)
- Key (member_seq) — int — Primary key — NOT NULL
- Field (name) — varchar2 — NOT NULL
- Field (age) — int — NOT NULL
- Field (sex) — int — NOT NULL
- Field (certified) — int — NOT NULL
- Field (phone) — varchar2 — NOT NULL
Untitled (defect)
- Key (defect_seq) — int — Primary key — NOT NULL
- Key (member_seq) — int — Foreign key → Untitled.Key — NOT NULL
- Key (image_seq) — int — Foreign key → Untitled.Key — NOT NULL
- Key (wall_seq) — int — Foreign key → Untitled.Key
- Key (ceiling_seq) — int — Foreign key → Untitled.Key
- Key (floor_seq) — int — Foreign key → Untitled.Key
- Field (content) — varchar2 — NOT NULL
Untitled (Image)
- Key (image_seq) — int — Primary key — NOT NULL
- Key (wall_seq) — int — Foreign key → Untitled.Key
- Key (ceiling_seq) — int — Foreign key → Untitled2.Key
- Key (floor_seq) — int — Foreign key → Untitled3.Key
- Field (image) — CLOB — NOT NULL
Untitled2 (ceiling)
- Key (ceiling_seq) — int — Primary key — NOT NULL
- Key (room_seq) — int — Foreign key → Untitled.Key — NOT NULL
Untitled3 (floor)
- Key (floor_seq) — int — Primary key — NOT NULL
- Key (room_seq) — int — Foreign key → Untitled.Key — NOT NULL