Browny

Tables (7)

Untitled (class_info)

  • Key (class_no) — bigint — Primary key — NOT NULL
  • Key (instructor1_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (instructor2_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field2 (genre) — char(1) — NOT NULL
  • Field (type) — char(1) — NOT NULL
  • Field (is_only) — char(1)
  • Field3 (region) — varchar(100) — NOT NULL
  • Field (strat_date) — Date — NOT NULL
  • Field2 (end_date) — Date — NOT NULL
  • Field (date_summary) — varchar(100) — NOT NULL
  • Field3 (start_time) — varchar(100) — NOT NULL
  • Field4 (end_time) — varchar(100) — NOT NULL
  • Field (price_male) — int
  • Field2 (price_female) — int
  • Field (payment) — varchar(100)
  • Field (location) — char(1)

Untitled (user_info)

  • Key (user_no) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar(100)
  • Field (sex) — char(1) — NOT NULL
  • Field (is_instructor) — Bool — NOT NULL
  • Field (phone_no) — varchar(100)
  • Field (kakao_id) — varchar(100)
  • Field (payment) — varchar(100)

Untitled (career_info)

  • Key (no) — bigint — Primary key — NOT NULL
  • Key (user_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (career) — varchar(100)
  • Field (link) — varchar(100)

Untitled (class_contact_info)

  • Key (no) — bigint — Primary key — NOT NULL
  • Key (class_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (contact) — varchar(100)

Untitled (class_date_info)

  • Key — Primary key — NOT NULL
  • Key (class_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (info) — varchar(100)

Untitled (class_time_info)

  • Key (no) — bigint — Primary key — NOT NULL
  • Key (class_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (info) — varchar(100)

Untitled (earlybird_info)

  • Key (class_no) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (deadline) — varchar(10) — NOT NULL
  • Field (amount) — int — NOT NULL