공통컴포넌트 전체 코멘트 오라클 sql 있나요?
- 작성자 :
- 이*행
- 작성일 :
- 2012-09-12 18:08:23
- 조회수 :
- 1,416
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
com4_DDL_Oracle.sql 코멘트가 없네요.
코멘트 쿼리 좀 받을 수 있나요? 전체 테이블이요.
----------------------------------------------------------------------------------------------------
COMMENT ON TABLE COMTNGNRLMBER IS '일반회원';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_ID IS '회원ID';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD IS '비밀번호';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD_HINT IS '비밀번호힌트';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD_CNSR IS '비밀번호정답';
COMMENT ON COLUMN COMTNGNRLMBER.IHIDNUM IS '주민등록번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_NM IS '회원명';
COMMENT ON COLUMN COMTNGNRLMBER.ZIP IS '우편번호';
COMMENT ON COLUMN COMTNGNRLMBER.ADRES IS '주소';
COMMENT ON COLUMN COMTNGNRLMBER.AREA_NO IS '지역번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_STTUS IS '회원상태';
COMMENT ON COLUMN COMTNGNRLMBER.DETAIL_ADRES IS '상세주소';
COMMENT ON COLUMN COMTNGNRLMBER.END_TELNO IS '끝전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBTLNUM IS '이동전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.GROUP_ID IS '그룹ID';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_FXNUM IS '회원팩스번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_EMAIL_ADRES IS '회원이메일주소';
COMMENT ON COLUMN COMTNGNRLMBER.MIDDLE_TELNO IS '중간전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.SBSCRB_DE IS '가입일자';
COMMENT ON COLUMN COMTNGNRLMBER.SEXDSTN_CODE IS '성별코드';
COMMENT ON COLUMN COMTNGNRLMBER.ESNTL_ID IS '고유ID';
코멘트 쿼리 좀 받을 수 있나요? 전체 테이블이요.
----------------------------------------------------------------------------------------------------
COMMENT ON TABLE COMTNGNRLMBER IS '일반회원';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_ID IS '회원ID';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD IS '비밀번호';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD_HINT IS '비밀번호힌트';
COMMENT ON COLUMN COMTNGNRLMBER.PASSWORD_CNSR IS '비밀번호정답';
COMMENT ON COLUMN COMTNGNRLMBER.IHIDNUM IS '주민등록번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_NM IS '회원명';
COMMENT ON COLUMN COMTNGNRLMBER.ZIP IS '우편번호';
COMMENT ON COLUMN COMTNGNRLMBER.ADRES IS '주소';
COMMENT ON COLUMN COMTNGNRLMBER.AREA_NO IS '지역번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_STTUS IS '회원상태';
COMMENT ON COLUMN COMTNGNRLMBER.DETAIL_ADRES IS '상세주소';
COMMENT ON COLUMN COMTNGNRLMBER.END_TELNO IS '끝전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBTLNUM IS '이동전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.GROUP_ID IS '그룹ID';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_FXNUM IS '회원팩스번호';
COMMENT ON COLUMN COMTNGNRLMBER.MBER_EMAIL_ADRES IS '회원이메일주소';
COMMENT ON COLUMN COMTNGNRLMBER.MIDDLE_TELNO IS '중간전화번호';
COMMENT ON COLUMN COMTNGNRLMBER.SBSCRB_DE IS '가입일자';
COMMENT ON COLUMN COMTNGNRLMBER.SEXDSTN_CODE IS '성별코드';
COMMENT ON COLUMN COMTNGNRLMBER.ESNTL_ID IS '고유ID';
A
안녕하세요.. 이백행님..
코멘트를 포함한 쿼리는 별도로 없습니다..
그럼.. 즐거운 하루되십시오.
감사합니다.
코멘트를 포함한 쿼리는 별도로 없습니다..
그럼.. 즐거운 하루되십시오.
감사합니다.
