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