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