dd
Tables (6)
class (강의 정보)
- class_idx (PK) — int — Primary key — NOT NULL
- teacher_id (Field) — varchar
- class_name (Field2) — varchar
- class_day (Field3) — varchar
- str_day (Field4) — varchar
- end_day (Field5) — varchar
class_time (강의 시간)
- class_week (PK1) — Primary key — NOT NULL
- Key2 (PK2) — Primary key — NOT NULL
- Key3 (PK3) — Primary key — NOT NULL
room (강의실 정보)
- room_idx (PK) — int — Primary key — NOT NULL
- room_nm (Field) — varchar
- room_max (Field2) — int
- Field3
school_code (학교정보)
- schl_idx (PK) — int — Primary key — NOT NULL
- SCHL_NM (Field) — varchar
- CTPV_EDU_NM (Field2) — varchar
- SCHL_ROSD_ADDR (Field3) — int
- SCHL_ADDR (Field4) — varchar
- Field5
tb_user (사용자)
- user_id (PK) — varchar — Primary key — NOT NULL
- schl_idx (FK) — int — Foreign key → school_code.schl_idx — NOT NULL
- user_password (Field) — varchar
- user_nm (Field2) — varchar
- stud_adventage (Field3) — int
- sutd_disadvantage (Field4) — int
- user_type (Field5) — varchar
- stud_nick_name (Field6) — varchar