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)