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