GPT
Tables (12)
Attendance
- CLOG_NO — NUMBER(10) — Foreign key → COURSE_LOG.CLOG_NO — NOT NULL
- ID — VARCHAR2(30) — Foreign key → MEMBERS.ID — NOT NULL
- ATTEND — VARCHAR2(30)
- COURSE_ID — VARCHAR2(30) — Foreign key → COURSE.COURSE_ID — NOT NULL
BOARD
- BNO — NUMBER(10) — Primary key — NOT NULL
- VARCHAR2(30) — VARCHAR2(30) — NOT NULL
- 이하생략 — VARCHAR(255)
COUNSEL
- COUNSEL_NO — NUMBER(10) — Primary key — NOT NULL
- COUNSEL_TYPE — VARCHAR2(30)
- COUNSEL_CONTENT — VARCHAR2(50)
- COUNSEL_SF — VARCHAR2(50)
- COURSE_ID — VARCHAR2(30) — Foreign key → COURSE.COURSE_ID — NOT NULL
- ID2 — VARCHAR2(30) — Foreign key → MEMBERS.ID — NOT NULL
COURSE
- COURSE_ID — VARCHAR2(30) — Primary key — NOT NULL
- COURSE_NAME — VARCHAR2(30)
- COURSE_TYPE — VARCHAR2(20)
- TEACHER — VARCHAR2(20)
- START_DATE — VARCHAR2(20)
- END_DATE — VARCHAR2(20)
- DAYS — VARCHAR2(20)
COURSE_LIST
- CLIST_NO — NUMBER(10) — Primary key — NOT NULL
- ID — VARCHAR2(30) — Foreign key → MEMBERS.ID — NOT NULL
- COURSE_ID — VARCHAR2(30) — Foreign key → COURSE.COURSE_ID — NOT NULL
- REG_DATE — DATE
COURSE_LOG
- CLOG_NO — NUMBER(10) — Primary key — NOT NULL
- COURSE_ID — VARCHAR2(30) — Foreign key → COURSE.COURSE_ID — NOT NULL
- REG_DATE — DATE
- 재적 — VARCHAR(255)
- 출석 — VARCHAR(255)
- 결석 — VARCHAR(255)
- 지각 — VARCHAR(255)
- 조퇴 — VARCHAR(255)
- 실습시간 — VARCHAR(255)
- 이런시간 — VARCHAR(255)
- 지시사항 — VARCHAR(255)
- 특이사항 — VARCHAR(255)
- 결재여부 — CHAR(1)
Customer
- CustomerID — INT
- Name — VARCHAR(100)
- Phone — VARCHAR(20)
- Address — VARCHAR(255)
LOG_LIST
- LIST_NO — NUMBER(10) — Primary key — NOT NULL
- 교시 — VARCHAR(255)
- 훈련과목 — VARCHAR(255)
- 담당교사 — VARCHAR(255)
- 훈련내용 — VARCHAR(255)
- CLOG_NO — NUMBER(10) — Foreign key → COURSE_LOG.CLOG_NO — NOT NULL
MEMBERS
- ID — VARCHAR2(30) — Primary key — NOT NULL
- PW — VARCHAR2(30)
- MEMBER_NO — VARCHAR2(30)
- NAME — VARCHAR2(30)
- PHONE — VARCHAR2(30)
- GRADE_NAME — VARCHAR2(30)
Order
- OrderID — INT
- OrderDate — DATE
- PaymentMethod — VARCHAR(50)
- CustomerID — INT
OrderDetails
- OrderDetailsID — INT
- OrderID — INT
- ProductID — INT
- Quantity — INT
- Price — DECIMAL(10, 2)
Product
- ProductID — INT
- ProductName — VARCHAR(100)
- Price — DECIMAL(10, 2)
- Stock — INT