Homework
Tables (6)
RE_AVA_INFO (예약가능정보)
- REZ_INFO_SEQ (예약가능정보순번) — DECIMAL — Primary key — NOT NULL
- REST_ID (음식점ID) — DECIMAL — Foreign key → RE_REST_MST.REST_ID — NOT NULL
- ID (사용자ID2) — DECIMAL — Foreign key → RE_REST_MST.OWNER_ID — NOT NULL
- REZ_TIME_CD (예약시간코드) — VARCHAR
- REZ_POS_CNT (예약가능인원) — DECIMAL
- REZ_PAY_YN (예약금발생여부) — VARCHAR
- REZ_PAY (예약금) — DECIMAL
- MAX_AVA_TM (최대이용시간) — VARCHAR
- REZ_RMK (비고) — VARCHAR
- CRT_ID (생성사용자ID (FK)) — DECIMAL
- CRT_DT (생성일시) — VARCHAR
- UPDT_ID (변경사용자ID (FK)) — DECIMAL
- UPDT_DT (변경일시) — VARCHAR
RE_REST_HOLY_MST (음식점 휴무)
- HOLY_SEQ (휴무순번) — DECIMAL — Primary key — NOT NULL
- REST_ID (음식점ID(PK)) — DECIMAL — Foreign key → RE_REST_MST.REST_ID — NOT NULL
- REST_ID (휴무일자) — VARCHAR
- CRT_ID (생성사용자ID (FK)) — DECIMAL
- CRT_DT (생성일시) — VARCHAR
- UPDT_ID (변경사용자ID (FK)) — DECIMAL
- UPDT_DT (변경일시) — VARCHAR
RE_REST_MST (음식점마스터)
- REST_ID (음식점ID) — DECIMAL — Primary key — NOT NULL
- OWNER_ID (업주ID) — DECIMAL — Foreign key → TB_USER.ID — NOT NULL
- BIZRG_NO (사엄자등록번호) — VARCHAR
- REST_NM (음식점명) — VARCHAR
- REST_DESC (음식점설명) — VARCHAR
- REST_RMK (편의시설) — VARCHAR
- PHN_NO (전화번호) — VARCHAR
- ADDR (주소) — VARCHAR
- LOC (지역코드) — VARCHAR
- SALES_HOUR (영업시간) — VARCHAR
- RSV_STRT_DATE (예약가능시작일자) — VARCHAR
- RSV_END_DATE (예약가능종료일자) — VARCHAR
- BIZ_TYPE_CD (업종코드) — VARCHAR
- ENABLE_PER (최대수용인원) — DECIMAL
- RESR_MGR_ID (음식점관리자사용자ID (FK)) — DECIMAL
- APPR_STAT_CD (결재상태코드) — DECIMAL
- APPR_USR_ID (결재사용자ID (FK)) — DECIMAL
- APPR_COMMENT (결재의견) — VARCHAR
- CRT_ID (생성사용자ID (FK)) — DECIMAL
- CRT_DT (생성일시) — VARCHAR
- UPDT_ID (변경사용자ID (FK)) — DECIMAL
- UPDT_DT (변경일시) — VARCHAR
RE_REZ_MST (예약마스터)
- REZ_NO (예약번호) — VARCHAR — Primary key — NOT NULL
- REST_ID (음식점ID (PK)) — DECIMAL — Foreign key → RE_REST_MST.REST_ID — NOT NULL
- REZ_INFO_SEQ (예약가능정보순번( = 예약가능SEQ) (PK)) — DECIMAL — Foreign key → RE_AVA_INFO.REZ_INFO_SEQ — NOT NULL
- RE_USER_ID (사용자ID) — DECIMAL — Foreign key → TB_USER.ID — NOT NULL
- ID (사용자ID2) — DECIMAL — Foreign key → RE_REST_MST.OWNER_ID — NOT NULL
- REZ_DATE (예약일자) — VARCHAR
- REZ_TIME_CD (예약시간코드) — VARCHAR
- REZ_CNT (예약자수) — DECIMAL
- REZ_STAT_CD (예약상태코드) — VARCHAR
- REZ_CNCL_RMK (취소사유) — VARCHAR
- REZ_APPR_USER_ID (예약승인사용자ID (FK)) — DECIMAL
- REZ_APPR_COMMENT (확정의견) — VARCHAR
- CRT_ID (생성사용자ID (FK)) — DECIMAL
- CRT_DT (생성일시) — VARCHAR
- UPDT_ID (변경사용자ID (FK)) — DECIMAL
- UPDT_DT (변경일시) — VARCHAR
TB_USER (공통사용자)
- ID (사용자ID) — DECIMAL — Primary key — NOT NULL
- U_NAME (사용자명) — VARCHAR
- USR_NAME (로그인 ID) — VARCHAR
- Field
TB_USER_ROLE (사용자권한관리)
- ID (퀀한ID) — INT — Primary key — NOT NULL
- TITLE (권한명) — VARCHAR