Mamitto

테이블 (6)

게시글 (POSTS)

  • PK (PO_NUM) — NUMBER — 기본 키 — NOT NULL
  • NN (PO_TITLE) — VARCHAR2(100)
  • NN (PO_CONTENT) — VARCHAR2(500)
  • NN (PO_PW) — VARCHAR2(100)
  • FK (EMAIL) — VARCHAR2(100) — 외래 키 → 회원.PK — NOT NULL
  • NN (PO_TIME) — TIMESTAMP

생활리듬관리시스템 (RHYTHM)

  • PK (RH_NUM) — NUMBER — 기본 키 — NOT NULL
  • NN (RH_CATEGORY) — VARCHAR2(100)
  • NN (RH_MEAL) — VARCHAR2(100)
  • NN (RH_DEFECATE) — VARCHAR2(100)
  • NN (RH_SLEEP) — TIMESTAMP
  • NN (RH_TIME) — TIMESTAMP
  • FK (EMAIL) — VARCHAR2(100) — 외래 키 → 아기.PK — NOT NULL

신체측정 (BODYCHECK)

  • PK (BD_NUM) — NUMBER — 기본 키 — NOT NULL
  • NN (BD_HEIGHT) — VARCHAR2(100)
  • NN (BD_WEIGHT) — VARCHAR2(100)
  • NN (BD_TIME) — TIMESTAMP
  • FK (EMAIL) — VARCHAR2(100) — 외래 키 → 아기.PK — NOT NULL

아기 (BABYS)

  • PK (EMAIL) — VARCHAR2(100) — 외래 키 → 회원.PK — NOT NULL
  • NN (BABY_NAME) — VARCHAR2(100)
  • NN (BABY_BIRTH) — DATE
  • NN (BABY_GENDER) — VARCHAR2(100)
  • NN (CAM_IP) — VARCHAR2(100)

알람히스토리 (HISTORY)

  • PK (ACT_NUM) — NUMBER — 기본 키 — NOT NULL
  • NN (ACTION) — VARCHAR2(100)
  • NN (ACT_TIME) — TIMESTAMP
  • Field (LEVEL) — NUMBER
  • PK (EMAIL) — VARCHAR2(100) — 외래 키 → 아기.PK — NOT NULL

회원 (MEMBERS)

  • PK (EMAIL) — VARCHAR2(100) — 기본 키 — NOT NULL
  • NN (PW) — VARCHAR2(100)
  • NN (NAME) — VARCHAR2(100)
  • NN (AGE) — NUMBER
  • NN (TEL) — VARCHAR2(100)