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