SKINOTE
Tables (3)
COURSE (시술코스)
- COURSE_ID (Key) — VARCHAR2(40) — Primary key — NOT NULL
- STORE_ID (Field)
STORE (가게)
- STORE_ID (Key) — Primary key — NOT NULL
- USER_ID (Key2) — VARCHAR2(60) — Foreign key → USER.USER_ID — NOT NULL
- STORE_NAME (Field3)
- OWNER_NAME (Field4)
- OWNER_TEL (Field5)
- BUSINESS_NO (Field6)
- STORE_ADDR (Field7)
- STORE_START_HOUR (Field8)
- STORE_END_HOUR (Field2)
- DAY_OFF (Field9)
- IS_BUFFER_MIN (Field15)
- BUFFER_MINUTES (Field10)
- IS_USED (Field11) — VARCHAR2(2)
- IS_USED_AT (Field12) — DATE
- IN_DT (Field) — DATE
- UP_DT (Field13) — DATE
USER (사용자)
- USER_ID (Key) — VARCHAR2(60) — Primary key — NOT NULL
- EMAIL (Field)
- USER_NAME (Field2)
- USER_TEL (Field6)
- SOCIAL_PROWIDER (Field3)
- IN_DT (Field4)
- UP_DT (Field5)