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)