cork
Tables (6)
CORKAGE_INFO
- STORE_SEQ — decimal(18, 0)
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
CORKAGE_LIST
- store_seq — decimal(18,0) — Primary key — NOT NULL
- phone — varchar(45)
- id — int
- place_name — varchar(45)
- road_address_name — varchar(45)
- x — varchar(45)
- y — varchar(45)
- category_group_name — varchar(45)
DRINK_INFO
- DRINK_SEQ — int — NOT NULL
- DRINK_NAME — VARCHAR(255) — NOT NULL
- BRAND — VARCHAR(100)
- DRINK_TYPE — VARCHAR(50)
- ALCOHOL_CONTENT — VARCHAR(10)
- DRINK_VOLUME — VARCHAR(50)
- DRINK_ORIGIN — VARCHAR(100)
- DESCRIPTION — TEXT
- PRICE — DECIMAL(10, 2)
SR_INFO
- SR_SEQ — decimal(18, 0)
- STATUS — char(1)
- SR_TYPE — varchar(10)
- SVC — varchar(20)
- RSV_KIND — varchar(20)
- RSV_SEQ — varchar(10)
- REQUEST_DEPT — varchar(2)
- TARGET_DEPT — varchar(2)
- TARGET_DATE — varchar(8)
- TITLE — varchar(200)
- CONTENTS — varchar(300)
- PROC_ID — varchar(30)
- PROC_IP — varchar(50)
- ADD_DATE — varchar(8)
- ADD_TIME — varchar(6)
- WRITE_DATE — datetime
- CHANGE_DATE — datetime
- MEMO — varchar(200)
- REPLY_CNT — smallint
- VIEW_CHECK — smallint
SR_RESP
- SR_RESP_SEQ — decimal(18, 0) — NOT NULL
- SR_SEQ — decimal(18, 0) — NOT NULL
- RESP_STATUS — char(1)
- RESP_GROUP — smallint
- RESP_LEVEL — smallint
- RESP_STEP — smallint
- RESP_CHILD — smallint
- CONTENTS — text
- PROC_ID — varchar(20)
- ADD_DATE — varchar(8)
- ADD_TIME — varchar(6)
- CHANGE_DATE — datetime
- MEMO — varchar(200)
SVCMANAGER
- MANAGER_SEQ — decimal(18, 0) — Primary key
- USER_ID — varchar(50)
- USER_NAME — varchar(50)
- USER_PASSWD — varchar(200)
- EMAIL — varchar(300)
- STATUS — char(1)
- AUTH — varchar(4)
- PHONE_NUM — varchar(50)
- PWD_CHANGE_DATE — datetime
- LOGIN_DATE — datetime
- LOGIN_IP — varchar(20)
- LOGOUT_DATE — datetime
- CHANGE_ID — varchar(30)
- CHANGE_DATE — datetime
- WRITE_DATE — datetime
- MEMO — varchar(200)