KH PJ

Tables (28)

CATEGORY (category)

  • CATEGORY_CODE (category_code) — varchar2(10) — Primary key — NOT NULL
  • CATEGORY_NAME (category_name) — varchar2(20)

CENTER (center)

  • CENTER_CODE (center_code) — varchar2(10) — Primary key — NOT NULL
  • CENTER_NAME (center_name) — varchar2(20)
  • CENTER_ADDRESS (center_address) — varchar2(100)
  • CENTER_PHONE (center_phone) — varchar2(14)
  • CENTER_OPERATING_HOURS (center_operating_hours) — varchar2(200)
  • CENTER_HOLIDAY (center_holiday) — varchar2(200)
  • CENTER_SCHEDULE (center_schedule) — varchar2(200)
  • CENTER_TEXT (center_text) — varchar2(200)
  • C_MAIN_IMAGE (사업자등록번호) — varchar2(50)
  • APPROVAL (승인여부) — char(1)
  • MEMBER_CODE — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • SNS_HOMEPAGE (Field) — varchar2(200)
  • SNS_INSTAGRAM (Field2) — varchar2(200)
  • SNS_BLOG (Field3) — varchar2(200)
  • SNS_ETC (Field4) — varchar2(200)
  • C_ENROLLDATE (Field5) — date(10)

CENTERXY (Untitled3)

  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • C_X (Field) — varchar2(200)
  • C_Y (Field2) — varchar2(200)

CENTER_IMAGE (center_image)

  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • F_IMAGE (f_image) — varchar2(20)

CENTER_OLD (CopyOfcenter)

  • CENTER_CODE (center_code) — varchar2(10) — Primary key — NOT NULL
  • CENTER_NAME (center_name) — varchar2(20)
  • CENTER_ADDRESS (center_address) — varchar2(100)
  • CENTER_PHONE (center_phone) — varchar2(14)
  • CENTER_OPERATING_HOURS (center_operating_hours) — varchar2(200)
  • CENTER_HOLIDAY (center_holiday) — varchar2(200)
  • CENTER_SCHEDULE (center_schedule) — varchar2(200)
  • CENTER_TEXT (center_text) — varchar2(200)
  • C_MAIN_IMAGE (사업자등록번호) — varchar2(50)
  • APPROVAL (승인여부) — char(1)
  • MEMBER_CODE — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • SNS_HOMEPAGE (Field) — varchar2(200)
  • SNS_INSTAGRAM (Field2) — varchar2(200)
  • SNS_BLOG (Field3) — varchar2(200)
  • SNS_ETC (Field4) — varchar2(200)
  • C_ENROLLDATE (Field5) — date(10)

C_CATEGORY (c_category)

  • CATEGORY_CODE (category_code) — varchar2(10) — Foreign key → CATEGORY.CATEGORY_CODE — NOT NULL
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL

C_PREFERENCE (c_preference)

  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL

C_PRICE (c_price)

  • PROGRAM_CODE (program_code) — varchar2(10) — Foreign key → C_PROGRAM.PROGRAM_CODE — NOT NULL
  • PRICE (price) — number(10)
  • MONTH (month) — number(10)

C_PROGRAM (c_program)

  • PROGRAM_CODE (program_code) — varchar2(10) — Primary key — NOT NULL
  • PROGRAM_NAME (program_name) — varchar2(20)
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL

FACILITY (편의시설)

  • FACILITY_CODE (편의시설_코드) — varchar2(10) — Primary key — NOT NULL
  • FACILITY_NAME (편의시설_이름) — varchar2(200)

MEMBER (member)

  • MEMBER_CODE (memer_code) — number — Primary key — NOT NULL
  • MEMBER_ID (member_id) — varchar2
  • MEMBER_PW (member_pw) — varchar2
  • MEMBER_NAME (member_name) — varchar2
  • MEMBER_EMAIL (member_email) — varchar2
  • MEMBER_PHONE (member_phone) — varchar2
  • MEMMBER_ADDRESS (member_address) — varchar2
  • MEMBER_LEVEL (member_level) — number
  • M_ENROLLDATE (상태) — date(10)
  • M_STATUS (멤버프로필사진경로) — char
  • M_IMAGE (Field) — varcahr2
  • M_PHONE_2 (Field2) — varchar2
  • M_ADDRESS (Field3) — varchar2
  • M_GENDER (Field4) — char
  • M_AGE (Field5) — varchar2
  • BUSINESS_CODE (Field6) — varchar2

MSG (Untitled4)

  • MSG_CODE (Key) — varchar2(10) — Primary key — NOT NULL
  • RECV_ID (memer_code) — number — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • SENT_ID (memer_code2) — number — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • TITLE (Field) — varchar2(200)
  • NOTE (Field2) — varchar2(200)
  • DATE_SENT (Field3) — DATE
  • DATE_READ (Field4) — date(10)
  • RECVREAD (Field5) — Y/N
  • RECV_DEL (Field6) — Y/N
  • SENT_DEL (Field7) — Y/N

NOTICE (board)

  • N_CODE (board_code) — varchar2(10) — Primary key — NOT NULL
  • N_CONTENT (board_content) — varchar2(200)
  • N_DATE (board_date) — date(10)
  • ORI_FILENAME (ori_filename) — varchar2(200)
  • NEW_FILENAME (new_filename) — varchar2(200)
  • TITLE (title) — varchar2(100)
  • READCOUNT (readcount) — number(10)
  • MEMBER_NAME (memer_name) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • N_STATUS (상태) — char(1)

NOTICE_COMMENT (board_comment)

  • N_COMMENT_CODE (board_comment_code) — varchar2(10) — Primary key — NOT NULL
  • N_COMMENT_REF (board_comment_ref) — number(10) — Foreign key → NOTICE_COMMENT.N_COMMENT_CODE — NOT NULL
  • N_COMMENT_LEVEL (board_comment_level) — number(10)
  • N_COMMENT_CONTENT (board_comment_cotent) — varchar2(200)
  • N_COMMENT_DATE (board_comment_date) — date(10)
  • N_CODE (board_code) — varchar2(10) — Foreign key → NOTICE.N_CODE — NOT NULL

Q/A (q/a)

  • QA_CODE (board_code) — varchar2(10) — Primary key — NOT NULL
  • QA_CONTENT (board_content) — varchar2(200)
  • QA_DATE (board_date) — date(10)
  • ORI_FILENAME (ori_filename) — varchar2(200)
  • NEW_FILENAME (new_filename) — varchar2(200)
  • TITLE (title) — varchar2(100)
  • READCOUNT (readcount) — number(10)
  • MEMBER_CODE (member_CODE) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • QA_STATUS (상태) — char(1)

Q/A_COMMENT (q/a_comment)

  • QA_COMMENT_CODE (board_comment_code) — varchar2(10) — Primary key — NOT NULL
  • QA_COMMENT_LEVEL (board_comment_level) — number(10)
  • QA_COMMENT_CONTENT (board_comment_cotent) — varchar2(200)
  • QA_COMMENT_DATE (board_comment_date) — date(10)
  • BOARD_COMMENT_REF (board_comment_code2) — varchar2(10) — Foreign key → Q/A_COMMENT.QA_COMMENT_CODE — NOT NULL
  • QA_CODE (board_comment_ref) — number(10) — Foreign key → Q/A.QA_CODE — NOT NULL
  • MEMBER_CODE (memer_code) — number — Foreign key → MEMBER.MEMBER_CODE — NOT NULL

TRAINER (trainer)

  • TRAINER_CODE (trainer_code) — varchar2(10) — Primary key — NOT NULL
  • TRAINER_COUNSEL_HOURS (trainer_counsel_hours) — varchar2(100)
  • TRAINER_INTRODUCTION (trainer_introduction) — varchar2(100)
  • TRAINER_CAREER (trainer_career) — varchar2(100)
  • T_TEXT (사업자등록번호) — varchar2(50)
  • T_MAIN_IMG (승인여부) — char(1)
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • APPROVAL (Field) — CHAR
  • SNS_HOMEPAGE (Field2) — varchar2(200)
  • SNS_INSTAGRAM (Field3) — varchar2(200)
  • SNS_BLOG (Field4) — varchar2(200)
  • SNS_ETC (Field5) — varchar2(200)
  • T_ENROLLDATE (Field6) — date(10)

TRAINER_IMAGE (trainer_image)

  • TRAINER_CODE (trainer_code) — varchar2(10) — Foreign key → TRAINER.TRAINER_CODE — NOT NULL
  • T_IMAGE (t_image) — varchar2(20)

TRAINER_OLD (CopyOftrainer)

  • TRAINER_CODE (trainer_code) — varchar2(10) — Primary key — NOT NULL
  • TRAINER_COUNSEL_HOURS (trainer_counsel_hours) — varchar2(100)
  • TRAINER_INTRODUCTION (trainer_introduction) — varchar2(100)
  • TRAINER_CAREER (trainer_career) — varchar2(100)
  • T_TEXT (사업자등록번호) — varchar2(50)
  • T_MAIN_IMG (승인여부) — char(1)
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • APPROVAL (Field) — CHAR
  • SNS_HOMEPAGE (Field2) — varchar2(200)
  • SNS_INSTAGRAM (Field3) — varchar2(200)
  • SNS_BLOG (Field4) — varchar2(200)
  • SNS_ETC (Field5) — varchar2(200)
  • T_ENROLLDATE (Field6) — date(10)

T_CATEGORY (t_category)

  • TRAINER_CODE (trainer_code) — varchar2(10) — Foreign key → TRAINER.TRAINER_CODE — NOT NULL
  • CATEGORY_CODE (category_code) — varchar2(10) — Foreign key → CATEGORY.CATEGORY_CODE — NOT NULL

T_ORDER_HISTORY (p_bill)

  • ORDER_CODE (pay_code) — varchar2(10) — Primary key — NOT NULL
  • ORDER_DATE (paye_date) — date(10)
  • PROGRAM_CODE (program_code) — varchar2(10) — Foreign key → T_PROGRAM.P_CODE — NOT NULL
  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • COUNT — NUMBER(10)
  • SCORE (Field) — NUMBER(10)

T_ORDER_history_comment (CopyOfUntitled2)

  • T_COMMENT_CODE (Key) — NUMBER — Primary key — NOT NULL
  • C_COMMENT_LEVEL (Field) — NUMBER
  • MEMBER_CODE (memer_code) — number — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • C_COMMENT_CONTENT (Field2) — VARCHAR2
  • C_COMMENT_DATE (Field3) — DATE
  • STATUS (Field4) — CHAR
  • TRAINER_CODE (trainer_code) — varchar2(10) — Foreign key → TRAINER.TRAINER_CODE — NOT NULL
  • ORDER_CODE (pay_code) — varchar2(10) — Foreign key → T_ORDER_HISTORY.ORDER_CODE — NOT NULL
  • T_COMMENT_REF (Key2) — NUMBER — Foreign key → T_ORDER_history_comment.T_COMMENT_CODE — NOT NULL

T_PREFERENCE (t_preference)

  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • TRAINER_CODE (trainer_code) — varchar2(10) — Foreign key → TRAINER.TRAINER_CODE — NOT NULL

T_PRICE (Untitled)

  • PROGRAM_CODE (program_code) — varchar2(10) — Foreign key → T_PROGRAM.P_CODE — NOT NULL
  • PRICE (price) — number(10)
  • COUNT (count) — number(10)

T_PROGRAM (t_program)

  • P_CODE (program_code) — varchar2(10) — Primary key — NOT NULL
  • TRAINER_CODE (trainer_code) — varchar2(10) — Foreign key → TRAINER.TRAINER_CODE — NOT NULL
  • P_NAME (프로그램이름) — varchar2(10)
  • STATUS (상태(정원)) — char(1)

c_order_history (c_bill)

  • ORDER_CODE (pay_code) — varchar2(10) — Primary key — NOT NULL
  • ORDER_DATE (paye_date) — date(10)
  • PROGRAM_CODE (program_code) — varchar2(10) — Foreign key → C_PROGRAM.PROGRAM_CODE — NOT NULL
  • MEMBER_CODE (memer_code) — varchar2(10) — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • ORDER_EXPIRE_DATE (expire_date) — date(10)
  • MONTH — NUMBER(10)
  • SCORE (Field) — number(20)

c_order_history_comment (Untitled2)

  • C_COMMENT_CODE (Key) — NUMBER — Primary key — NOT NULL
  • C_COMMENT_LEVEL (Field) — NUMBER
  • MEMBER_CODE (memer_code) — number — Foreign key → MEMBER.MEMBER_CODE — NOT NULL
  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • C_COMMENT_REF (Key2) — varchar(20) — Foreign key → c_order_history_comment.C_COMMENT_CODE — NOT NULL
  • C_COMMENT_CONTENT (Field2) — VARCHAR2
  • C_COMMENT_DATE (Field3) — DATE
  • ORDER_CODE (pay_code) — varchar2(10) — Foreign key → c_order_history.ORDER_CODE — NOT NULL
  • STATUS (Field4) — CHAR

편의시설_관계

  • CENTER_CODE (center_code) — varchar2(10) — Foreign key → CENTER.CENTER_CODE — NOT NULL
  • FACILITY_CODE (편의시설_코드) — varchar2(10) — Foreign key → FACILITY.FACILITY_CODE — NOT NULL