Public Facility Reservation ERD

Tables (18)

ACC_AD

  • PK (ID) — VARCHAR2(50) — Primary key — NOT NULL
  • PK (CODE) — VARCHAR(100) — Foreign key → AREA.PK
  • NN (PW) — VARCHAR2(100) — NOT NULL
  • NN (NAME) — VARCHAR2(100) — NOT NULL
  • NN (PV_NUM) — NUMBER — NOT NULL
  • UK,NN (PH_NUM) — VARCHAR2(20) — NOT NULL

AREA

  • PK (CODE) — VARCHAR(100) — Primary key
  • PK (NAME) — VARCHAR2(100) — Primary key — NOT NULL
  • UK,NN (DP_NAME) — VARCHAR2(100) — Foreign key → DEP_INS.UK,NN — NOT NULL
  • NN (IN_NAME) — VARCHAR2(100) — Foreign key → DEP_INS.NN — NOT NULL

COM_RES_FC

  • PK,SK (CODE) — NUMBER — Primary key — NOT NULL
  • NN,SK (MONTH) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (WEEK_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_TIME) — VARCHAR2(10) — Primary key — NOT NULL
  • PK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • PK (USER_ID) — VARCHAR2(50) — Foreign key → USERS.PK — NOT NULL

DAY_FEE

  • PK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • NN (FEE) — NUMBER — NOT NULL
  • NN (START_TIME) — VARCHAR2(10) — NOT NULL
  • NN (END_TIME) — VARCHAR2(10) — NOT NULL

DEP

  • PK (NAME) — VARCHAR2(100) — Primary key — NOT NULL

DEP_INS (Untitled)

  • UK,NN (DP_NAME) — VARCHAR2(100) — Foreign key → DEP.PK — NOT NULL
  • NN (IN_NAME) — VARCHAR2(100) — Foreign key → INS.NN — NOT NULL

END_FEE

  • PK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • NN (FEE) — NUMBER — NOT NULL
  • NN (START_TIME) — VARCHAR2(10) — NOT NULL
  • NN (END_TIME) — VARCHAR2(10) — NOT NULL

END_RES_FC

  • PK,SK (CODE) — NUMBER — Primary key — NOT NULL
  • NN,SK (MONTH) — VARCHAR2(10) — Primary key
  • NN,SK (WEEK_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_TIME) — VARCHAR2(10) — Primary key — NOT NULL
  • PK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • PK (USER_ID) — VARCHAR2(50) — Foreign key → USERS.PK — NOT NULL

EV_FC_INF

  • PK (CODE) — NUMBER — Primary key — NOT NULL
  • NN (CL_VALUE) — NUMBER — NOT NULL
  • NN (AC_VALUE) — NUMBER — NOT NULL
  • NN (CT_VALUE) — NUMBER — NOT NULL
  • (DES) — VARCHAR2(50)
  • FK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • FK (USER_ID) — VARCHAR2(50) — Foreign key → USERS.PK — NOT NULL

FC

  • PK (CODE) — NUMBER — Primary key — NOT NULL
  • UK,NN (NAME) — VARCHAR2(100) — NOT NULL
  • NN (TYPE) — VARCHAR2(100) — NOT NULL
  • NN (MAX_TIME) — NUMBER — NOT NULL
  • NN (SUM_PEOPLE) — NUMBER — NOT NULL
  • NN (MS_SQ) — NUMBER(10,2) — NOT NULL
  • NN (IMG_URL) — VARCHAR2(100) — NOT NULL
  • NN (HOME_URL) — VARCHAR2(100) — NOT NULL
  • NN (FEE_YN) — VARCHAR2(10) — NOT NULL
  • NN (START_TIME) — VARCHAR2(10) — NOT NULL
  • NN (END_TIME) — VARCHAR2(10) — NOT NULL
  • Field (LAT) — NUMBER(10,4)
  • Field2 (LON) — NUMBER(10,4)
  • Field3 (ADDR_NEW) — VARCHAR2(100)
  • Field4 (PH_NUM) — VARCHAR2(50)
  • Field (DP_NAME) — VARCHAR2(100)
  • Field (AR_NAME) — VARCHAR2(100)

HOLI

  • SK,PK (WEEK_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • SK,PK (DAY_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • SK,PK (FC_CDOE) — NUMBER — Foreign key → FC.PK — NOT NULL

INS

  • NN (NAME) — VARCHAR2(100) — Primary key — NOT NULL

INS_PROV (Untitled2)

  • NN (IN_NAME) — VARCHAR2(100) — Foreign key → INS.NN — NOT NULL
  • UK,NN (PR_NAME) — VARCHAR2(100) — Foreign key → PROV.UK,NN — NOT NULL

PROV

  • UK,NN (NAME) — VARCHAR2(100) — Primary key — NOT NULL

PROVIDER_HISTORY (PROV_HIST)

  • SK,NN (PROV_DATE) — DATE — Primary key — NOT NULL
  • UK,NN (NAME) — VARCHAR2(100) — Foreign key → PROV.UK,NN — NOT NULL

PROV_ACC

  • PK (ID) — VARCHAR2(50) — Primary key — NOT NULL
  • NN (PW) — VARCHAR2(100) — NOT NULL
  • NN (NAME) — VARCHAR2(100) — NOT NULL
  • NN (PV_NUM) — NUMBER — NOT NULL
  • UK,NN (PH_NUM) — VARCHAR2(20) — NOT NULL
  • NN (ADDR) — VARCHAR2(100) — NOT NULL
  • UK,NN (NAME2) — VARCHAR2(100) — Foreign key → PROV.UK,NN — NOT NULL

RES_FC

  • PK (CODE) — NUMBER — Primary key — NOT NULL
  • NN,SK (WEEK_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_NUM) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (DAY_TIME) — VARCHAR2(10) — Primary key — NOT NULL
  • NN,SK (MONTH) — VARCHAR2(10) — Primary key — NOT NULL
  • PK (FC_CODE) — NUMBER — Foreign key → FC.PK — NOT NULL
  • PK (USER_ID) — VARCHAR2(50) — Foreign key → USERS.PK — NOT NULL

USERS

  • PK (ID) — VARCHAR2(50) — Primary key — NOT NULL
  • NN (PW) — VARCHAR2(100) — NOT NULL
  • NN (NAME) — VARCHAR2(100) — NOT NULL
  • NN (PV_NUM) — NUMBER — NOT NULL
  • UK,NN (PH_NUM) — VARCHAR2(20) — NOT NULL
  • NN (ADDR) — VARCHAR2(100) — NOT NULL
  • NN (Count) — NUMBER