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