test
Tables (3)
ADMIN_USER
- ADMIN_USER_SEQ — int(11) — Primary key — NOT NULL
- ADMIN_NAME — varchar(50)
- DELETE_FLAG — tinyint(4)
- ADD_DATE — datetime
- UPDATE_DATE — datetime
- ID — varchar(45)
- PASSWORD — varchar(120)
- MAIN_FLAG — tinyint(4)
CLINIC
- CLINIC_SEQ — int(11) — Primary key — NOT NULL — 병원 시퀀스
- DELETE_FLAG — tinyint(4)
- UPDATE_DATE — datetime
- ADD_DATE — datetime
- CLINIC_NAME — varchar(200)
- WEBSITE_URL — varchar(100)
- BANNER_IMG_URL — varchar(200)
- ADDRESS — varchar(300)
- MEMBER_CNT — int(11)
- MOBILE_SEQ — int(11)
- QUESTION_FORM_SEQ — int(11)
- TBP_TEMPLATE_NUM — int(11)
- TBP_REG_TYPE — int(11)
- TBP_FOOT_TYPE — tinyint(4)
- STREET — varchar(100)
- POST_CODE — varchar(100)
- CITY — varchar(50)
- COUNTRY — varchar(50)
- TIMEZONE — varchar(6)
- STATE — varchar(50)
- PHONE — varchar(50)
CLINIC_GROUP
- CLINIC_GROUP_SEQ — int(11) — Primary key — NOT NULL
- GROUP_NAME — varchar(200)
- DELETE_FLAG — tinyint(4)
- UPDATE_DATE — datetime
- ADD_DATE — datetime
- ADDRESS — varchar(300)
- PHONE — varchar(50)
- COUNTRY — varchar(50)