대정공원묘원
테이블 (25)
ACCMNG
- USER_ID — varchar(20) — NOT NULL
- USER_PW — varchar(20)
- USER_NAME — varchar(50)
- USER_DPTM — varchar(50)
- USER_DUTY — varchar(50)
- USER_TELNO — varchar(50)
- USER_HPNO — varchar(50)
- USER_EMAIL — varchar(100)
- USER_POST — varchar(6)
- USER_ADDR1 — varchar(150)
- USER_ADDR2 — varchar(150)
- USER_LEVEL — varchar(10)
- USER_AUTH — varchar(1)
- USER_PASSWORD_CHANGE_DATE — varchar(8)
- USER_REG_DATETIME — varchar(14)
- LOGINDTTIME — varchar(14)
- USERKIND — varchar(1)
CARDMNG
- ParkID — int — NOT NULL
- SEQNO — int — NOT NULL
- UPMU_GBN — varchar(20)
- PAY_STAT — varchar(20)
- DEAL_NO — varchar(50)
- PAY_KIND — varchar(50)
- PAY_RES_DTTM — varchar(14)
- PAY_RES_NO — varchar(35)
- PAY_AMT — float
- CARD_CD — varchar(10)
- CARD_NO — varchar(30)
- BANK_CD — varchar(5)
- BANK_NM — varchar(50)
- CANCEL_DTTM — varchar(14)
- REG_DTTM — varchar(14)
ENV
- KEYNO — int — NOT NULL
- COM_NM — varchar(50)
- BUSI_NO — varchar(15)
- REPR_NM — varchar(20)
- CNTC_PLC — varchar(20)
- CNTC_HP — varchar(20)
- CNTC_FAX — varchar(20)
- MAIL_ADDR — varchar(50)
- ADDR1 — varchar(150)
- ADDR2 — varchar(150)
- BZIT — varchar(100)
- BZTP — varchar(100)
- ACC_INFO — varchar(100)
- STAMP — varchar(250)
- INSYEAR — varchar(8)
- SCALE — varchar(20)
- SMSID — varchar(20)
- SMSPW — varchar(20)
- Use_Kind — int
- Over90DayRejectYN — varchar(1)
- Over7DayNoLogRjct — varchar(1)
FAMMNG
- ParkID — int — NOT NULL
- SEQNO — int — NOT NULL
- PDName — varchar(20)
- PDJumin — varchar(13)
- PDPost — varchar(6)
- PDAddr1 — varchar(150)
- PDAddr2 — varchar(150)
- PDSayu — varchar(250)
- PDYEAR — varchar(8)
- PDPLACE — varchar(200)
- REG_DTTM — varchar(14)
- REG_NM — varchar(20)
- EDT_DTTM — varchar(14)
- EDT_NM — varchar(20)
- PDDAY — varchar(8)
KKOENV
- SEQNO — int — NOT NULL
- KAKAO_TMPLETTL — varchar(100)
- KAKAO_MSG — varchar(100)
- KAKAO_TMPLECD — text
- KAKAO_SNDKEY — varchar(50)
- KAKAO_RSTMPLECD — varchar(50)
- KAKAO_KIND — varchar(10)
- BTNTYPE — varchar(1)
- KAKAO_BTNNM — varchar(100)
- KAKAO_BTNURL — text
- BTNTYPE2 — varchar(1)
- KAKAO_BTNNM2 — varchar(100)
- KAKAO_BTNURL2 — text
- BTNTYPE3 — varchar(1)
- KAKAO_BTNNM3 — varchar(100)
- KAKAO_BTNURL3 — text
- BTNTYPE4 — varchar(1)
- KAKAO_BTNNM4 — varchar(100)
- KAKAO_BTNURL4 — text
- BTNTYPE5 — varchar(1)
- KAKAO_BTNNM5 — varchar(100)
- KAKAO_BTNURL5 — text
- BTNCNT — varchar(2)
PARKCS
- PARKID — varchar(20) — NOT NULL
- SEQNO — int — NOT NULL
- CSMEMO — varchar(500)
- REG_NM — varchar(20)
- REG_DTTM — varchar(14)
- UDT_NM — varchar(20)
- UDT_DTTM — varchar(14)
- MAPPKEY — varchar(20)
- RCV_NM — varchar(50)
- RCV_NO — varchar(13)
- RCV_TEL — varchar(20)
- PCC_GBN — varchar(10)
- PCC_SND — varchar(4)
- PCC_RTNCD — varchar(10)
- PCC_RTNTEXT — varchar(200)
- PCC_SNDDT — varchar(14)
- PCC_TMPLCD — varchar(50)
- PCC_RSTMPLCD — varchar(50)
- PCC_TMPLETTL — varchar(100)
- PCC_MSG — text
- PCC_SNDSEQ — int
- PCC_IFCNV — varchar(1)
- PCC_KIND — varchar(10)
PARKMNG
- ParkID — int — NOT NULL
- PKey — varchar(20)
- PKeyMast — int
- PArea — varchar(20)
- PSize — varchar(20)
- PBI — int
- PGubun — varchar(50)
- PDDay — varchar(8)
- PTransDay — varchar(8)
- PName — varchar(20)
- PJumin — varchar(13)
- PDay — varchar(8)
- PRelation — varchar(8)
- PTel — varchar(14)
- PHpTel — varchar(14)
- PPost — varchar(6)
- PAddr1 — varchar(150)
- PAddr2 — varchar(150)
- PCntrNo — varchar(50)
- PCntrKind — varchar(50)
- PDName — varchar(20)
- PDJumin — varchar(13)
- PDPost — varchar(6)
- PDAddr1 — varchar(150)
- PDAddr2 — varchar(150)
- PDSayu — varchar(250)
- PDYEAR — varchar(8)
- PDPLACE — varchar(200)
- PBigo — varchar(500)
- PMemo — text
- SMSSEND — varchar(10)
- KKOSEND — varchar(10)
- KKOSNDDTTM — varchar(14)
- REG_DTTM — varchar(14)
- REG_NM — varchar(20)
- EDT_DTTM — varchar(14)
- EDT_NM — varchar(20)
- EMAIL — varchar(150)
- PGuest — varchar(20)
- PGHPTEL — varchar(14)
PAYMNG
- ParkID — int — NOT NULL
- SEQNO — int — NOT NULL
- PUMCD — varchar(5)
- PUMNM — varchar(100)
- PUMINFO — varchar(200)
- BILLDT — varchar(8)
- BILLAMT — float
- INDT — varchar(8)
- INAMT — float
- PMDATES — varchar(8)
- PMDATEE — varchar(8)
- PAYKIND — varchar(20)
- BIGO — varchar(250)
- PAYNM — varchar(20)
PUMGRP
- GRPCD — varchar(2) — NOT NULL
- GRPNM — varchar(50)
- EDT_DTTM — varchar(14)
- EDT_NM — varchar(20)
- REG_DTTM — varchar(14)
- REG_NM — varchar(20)
PUMMNG
- PUMCD — varchar(5) — NOT NULL
- PUMNM — varchar(100)
- DANGA — float
- PUMINFO — varchar(200)
- EDT_DTTM — varchar(14)
- EDT_NM — varchar(20)
- REG_DTTM — varchar(14)
- REG_NM — varchar(20)
ParkMember
- ParkID — int — 기본 키 — NOT NULL
- PKey — varchar(10)
- PArea — float
- PDay — smalldatetime
- PName — varchar(20)
- PDDay — smalldatetime
- PDName — varchar(20)
- PTel — varchar(14)
- PHpTel — varchar(14)
- PPost — varchar(7)
- PAddr1 — varchar(50)
- PAddr2 — varchar(50)
- PBigo — varchar(200)
- PGubun — varchar(10)
- PMemo — text
- PJobDay — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
ParkMoney
- PMID — int — 기본 키 — NOT NULL
- ParkID — int — 외래 키 → ParkMember.ParkID — NOT NULL
- PJDay — smalldatetime
- PJMoney — int
- PJName — varchar(20)
- PJPost — varchar(7)
- PJAddr1 — varchar(50)
- PJAddr2 — varchar(50)
- PMBigo — varchar(200)
- PBI — int
- PMDate1 — smalldatetime
- PMoney1 — int
- PMDateS1 — smalldatetime
- PMDateE1 — smalldatetime
- PMDate2 — smalldatetime
- PMoney2 — int
- PMDateS2 — smalldatetime
- PMDateE2 — smalldatetime
- PMDate3 — smalldatetime
- PMoney3 — int
- PMDateS3 — smalldatetime
- PMDateE3 — smalldatetime
- PMDate4 — smalldatetime
- PMoney4 — int
- PMDateS4 — smalldatetime
- PMDateE4 — smalldatetime
- PMDate5 — smalldatetime
- PMoney5 — int
- PMDateS5 — smalldatetime
- PMDateE5 — smalldatetime
- PMDate6 — smalldatetime
- PMoney6 — int
- PMDateS6 — smalldatetime
- PMDateE6 — smalldatetime
- PMDate7 — smalldatetime
- PMoney7 — int
- PMDateS7 — smalldatetime
- PMDateE7 — smalldatetime
- PMDate8 — smalldatetime
- PMoney8 — int
- PMDateS8 — smalldatetime
- PMDateE8 — smalldatetime
- PMDate9 — smalldatetime
- PMoney9 — int
- PMDateS9 — smalldatetime
- PMDateE9 — smalldatetime
- PMDate10 — smalldatetime
- PMoney10 — int
- PMDateS10 — smalldatetime
- PMDateE10 — smalldatetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
ParkNab
- PID — int — 기본 키 — NOT NULL
- PNKey — varchar(10) — NOT NULL
- PNDay — smalldatetime — NOT NULL
- PNMemo — varchar(300) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
ParkTempMoney
- PKey — varchar(50)
- PArea — float
- PJName — varchar(50)
- PMDate — smalldatetime
- Cnt — varchar(50)
- TMoney — varchar(50)
- PJPost — varchar(50)
- PJAddr1 — varchar(50)
- PJAddr2 — varchar(50)
SMSENV
- SEQNO — int — NOT NULL
- TMPLETTL — varchar(100)
- SMS_MSG — varchar(100)
- MMS_MSG — text
- SMS_TMPLECD — varchar(50)
- MMS_TMPLECD — varchar(50)
SPost
- PostCode — varchar(7) — NOT NULL
- sido — varchar(4)
- gugun — varchar(15)
- dong — varchar(60)
- bunji — varchar(17)
cnvverchk
- CnvDate — varchar(8) — NOT NULL
- CnvCode — varchar(35) — NOT NULL
- CnvName — varchar(70)
- CnvYN — char(1)
m7License
- SerialNumber — nchar(255)
- LicenseCode — nchar(255)
sys_auth_group
- author_code — varchar(30) — NOT NULL
- author_nm — varchar(60)
- author_dc — varchar(200)
- reg_dt — datetime
- reg_man — varchar(15)
- upd_dt — datetime
- upd_man — varchar(15)
sys_bbs_mgr
- board_id — int — NOT NULL
- board_nm — varchar(50)
- board_skin — varchar(250)
- list_level — char(1)
- view_level — char(1)
- write_level — char(1)
- reply_level — char(1)
- del_yn — char(1)
- reg_man — varchar(15)
- reg_dt — datetime
- upd_man — varchar(15)
- upd_dt — datetime
sys_com_code
- sn — int — NOT NULL
- code — varchar(32)
- group_code — varchar(32)
- code_nm — varchar(128)
- sort_ordr — decimal(10, 0)
- use_yn — char(1)
- rm — varchar(100)
- reg_dt — datetime
- reg_man — varchar(15)
- upd_dt — datetime
- upd_man — varchar(15)
sys_menu
- 메뉴번호 (menu_no) — decimal(20, 0) — NOT NULL
- upper_menu_no — decimal(20, 0)
- menu_nm — varchar(60)
- progrm_file_nm — varchar(60)
- menu_ordr — decimal(5, 0)
- menu_dc — varchar(250)
- menu_image_cours1 — varchar(100)
- menu_image_cours2 — varchar(100)
- menu_url — varchar(300)
- board_id — int
- role_pttrn — varchar(300)
- layout — varchar(100)
- gubun — varchar(10)
- del_yn — char(1)
- reg_dt — datetime
- reg_man — varchar(15)
- upd_dt — datetime
- upd_man — varchar(15)
sys_menu_auth
- menu_no — decimal(20, 0) — NOT NULL
- author_code — varchar(30) — NOT NULL
- reg_dt — datetime
- reg_man — varchar(15)
- upd_dt — datetime
- upd_man — varchar(15)
sys_user
- user_id — varchar(15) — NOT NULL
- user_nm — varchar(50)
- password — varchar(200)
- author_code — varchar(30)
- reg_dt — datetime
- reg_man — varchar(15)
- upd_dt — datetime
- upd_man — varchar(15)
tSPost
- PostCode — varchar(7) — NOT NULL
- sido — varchar(4)
- gugun — varchar(15)
- dong — varchar(60)
- bunji — varchar(17)