12123
Tables (16)
CAR
- CR_ID — INT — NOT NULL
- CR_NAME — VARCHAR(50) — NOT NULL
- CR_YEAR — INT — NOT NULL
- CR_FUEL_TYPE — ENUM("휘발유","경유","하이브리드","전기") — NOT NULL
- CR_TRANS — ENUM("오토","수동") — NOT NULL
- CR_TYPE — VARCHAR(50) — NOT NULL
- CR_PRICE — INT — NOT NULL
- CR_COUNT — INT — NOT NULL
- CR_RE_NUM — INT — Foreign key → RENTAL.RE_NUM — NOT NULL
CAR_PACKAGE
- CP_NUM — INT — NOT NULL
- CP_CR_ID — INT — Foreign key → CAR.CR_ID — NOT NULL
- CP_IR_NUM — INT — Foreign key → INSURANCEL.IR_NUM — NOT NULL
CHOICE_OPTION
- CO_NUM — INT — NOT NULL
- CO_DO_NUM — INT — Foreign key → DEFAULT_OPTION.DO_NUM — NOT NULL
- CO_TABLE — VARCHAR(20)
- CO_KEY — INT
DEFAULT_OPTION
- DO_NUM — INT — NOT NULL
- DO_NAME — VARCHAR(100)
DRIVER_INFOR
- DI_NUM — INT — NOT NULL
- DI_RR_NUM — INT — Foreign key → RE_RESERVATION.RR_NUM — NOT NULL
- DI_NAME — VARCHAR(10) — NOT NULL
- DI_NUMBER — INT(15) — NOT NULL
- DI_BIRTH — INT(20) — NOT NULL
INSURANCEL
- IR_NUM — INT — NOT NULL
- IR_TYPE — ENUM("대인","대물","X")
- IR_PRICE — INT — NOT NULL
LODGING
- LD_NUM — INT — NOT NULL
- LD_NAME — VARCHAR(100) — NOT NULL
- LD_REGION — VARCHAR(50) — NOT NULL
- LD_TYPE — ENUM("호텔","모텔","펜션") — NOT NULL
- LD_NUMBER — VARCHAR(20) — NOT NULL
- LD_RATING — INT
- LD_INFOR — LONGTEXT — NOT NULL
- LD_MEAL_PRICE — INT
- LD_ME_NUM — INT — Foreign key → MEMBER.ME_NUM — NOT NULL
- LD_RG_NUM — INT — Foreign key → REGION.RG_NUM — NOT NULL
LO_RESERVATION
- LR_NUM — INT — NOT NULL
- LR_CHECKIN — DATETIME — NOT NULL
- LR_CHECKOUT — DATETIME — NOT NULL
- LR_COUNT — INT — NOT NULL
- LR_TOTAL_PRICE — INT — NOT NULL
- LR_STATE — ENUM("예약완료","예약취소","환불완료") — NOT NULL
- LR_DATE — DATETIME — NOT NULL
- LR_BOOKER_NAME — VARCHAR(100)
- LR_GUEST_NAME — VARCHAR(100)
- LR_GUEST_NUMBER — VARCHAR(10)
- LR_CONTENT — VARCHAR(100)
- LR_MEAL_STATE — ENUM("Y","N")
- LR_ME_NUM — INT — Foreign key → MEMBER.ME_NUM — NOT NULL
- LR_RM_NUM — INT — Foreign key → ROOM.RM_NUM — NOT NULL
MEMBER
- ME_NUM — INT — NOT NULL
- ME_ID — VARCHAR(50) — NOT NULL
- ME_PW — LONGTEXT — NOT NULL
- ME_NAME — VARCHAR(10) — NOT NULL
- ME_NICK — VARCHAR(10) — NOT NULL
- ME_NUMBER — VARCHAR(15)
- ME_EMAIL — VARCHAR(50) — NOT NULL
- ME_AUTHORITY — ENUM("USER","ADMIN","OWNER") — NOT NULL
- ME_BIRTHDAY — CHAR(8) — NOT NULL
- ME_GENDER — ENUM("남자", "여자")
- ME_PROFILE — TEXT
- ME_PROVIDER — ENUM("NORMAL", "KAKAO", "NAVER", "GOOGLE") — NOT NULL
- ME_DEL — ENUM("Y", "N") — NOT NULL
REGION
- RG_NUM — INT — NOT NULL
- RG_NAME — VARCHAR(5) — NOT NULL
RENTAL
- RE_NUM — INT — NOT NULL
- RE_NAME — VARCHAR(20) — NOT NULL
- RE_NUMBER — VARCHAR(20) — NOT NULL
- RE_REGION — VARCHAR(50) — NOT NULL
- RE_ME_NUM — INT — Foreign key → MEMBER.ME_NUM — NOT NULL
- RE_CT_NUM — INT — Foreign key → REGION.RG_NUM — NOT NULL
REVIEW
- RV_NUM — INT — NOT NULL
- RV_RATING — INT — NOT NULL
- RV_CONTENT — TEXT — NOT NULL
- RV_DATE — DATE — NOT NULL
- RV_TABLE_NAME — VARCHAR(255) — NOT NULL
- RV_NUMBER — INT — NOT NULL
- RV_ME_NUM — INT — Foreign key → MEMBER.ME_NUM — NOT NULL
RE_RESERVATION
- RR_NUM — INT — NOT NULL
- RR_CHECKIN — DATETIME — NOT NULL
- RR_CHEKOUT — DATETIME — NOT NULL
- RR_PRICE — INT — NOT NULL
- RR_DATE — DATETIME — NOT NULL
- RR_STATE — ENUM — NOT NULL
- RR_CP_NUM — INT — Foreign key → CAR_PACKAGE.CP_NUM — NOT NULL
- RR_ME_NUM — INT — Foreign key → MEMBER.ME_NUM — NOT NULL
ROOM
- RM_NUM — INT — NOT NULL
- RM_NAME — VARCHAR(255) — NOT NULL
- RM_PRICE — INT — NOT NULL
- RM_PERSON — INT — NOT NULL
- RM_INFOR — VARCHAR(255) — NOT NULL
- RM_ROOMCOUNT — INT — NOT NULL
- RM_LD_NUM — INT — Foreign key → LODGING.LD_NUM — NOT NULL
THUMBNAIL
- TH_NUM — INT — NOT NULL
- TH_TABLE — VARCHAR(20)
- TH_KEY — INT
- TH_UPLOAD — VARCHAR(100)
- TH_NAME — VARCHAR(100)
USER_CHOICE_OPTION
- UC_NUM — INT — NOT NULL
- UC_CO_NUM — INT — Foreign key → CHOICE_OPTION.CO_NUM — NOT NULL
- UC_LR_NUM — INT — Foreign key → LO_RESERVATION.LR_NUM — NOT NULL