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