erd

Tables (5)

class (Untitled5)

  • Key — Primary key — NOT NULL
  • num (Field)
  • region_no
  • track_no

manager (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → class.Key — NOT NULL
  • 담당업무 — string
  • class_num — int
  • job_name — string

region (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → class.Key — NOT NULL
  • name — VARCHAR(1)

student (Untitled)

  • no — int — Primary key — NOT NULL
  • Key — Foreign key → class.Key — NOT NULL
  • number — int
  • is_major — VARCHAR(1)
  • is_exit — VARCHAR(1)
  • class — int

track (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → class.Key — NOT NULL
  • name — VARCHAR(1)