E-R Diagram
Tables (10)
DIARY (Untitled3)
- D_NO (Key1) — NUMBER — Primary key — NOT NULL
- ID (Key2) — VARCHAR2 — Foreign key → PROFILE.ID — NOT NULL
- D_TITLE (Field2) — VARCHAR2
- D_IMG (Field3) — VARCHAR2
- D_CONTENT (Field4) — VARCHAR2
- D_PRIVATE (Field5) — VARCHAR2
- D_REPLE (Field7) — VARCHAR2
D_DAY (Untitled2)
- ID (Key) — VARCHAR2 — Foreign key → PROFILE.ID — NOT NULL
- D_START (Field) — DATE
- D_END (Field2) — DATE
D_REPLE (Untitled10)
- D_NO (Key1) — NUMBER — Foreign key → DIARY.D_NO — NOT NULL
- ID (Key2) — VARCHAR2 — Foreign key → DIARY.ID — NOT NULL
- D_RE (Field) — VARCHAR2
ITEM (Untitled8)
- I_NO (Key2) — NUMBER — Foreign key → LIKE_ITEM.I_NO — NOT NULL
- I_NAME (Field) — VARCHAR2
- I_CONTENT (Field2) — VARCHAR2
- I_IMG (Field3) — VARCHAR2
LIKE_ITEM (Untitled7)
- I_NO (Key2) — NUMBER — Primary key — NOT NULL
- ID (Key) — VARCHAR2 — Foreign key → PROFILE.ID — NOT NULL
- SAVE (Field) — VARCHAR2
PROFILE (Untitled)
- ID (Key) — VARCHAR2 — Primary key — NOT NULL
- PW (Field2) — VARCHAR2
- NAME (Field3) — VARCHAR2
- NICK (Field4) — VARCHAR2
- TEL (Field5) — VARCHAR2
- ADDR (Field6) — VARCHAR2
- BIR (Field7) — DATE
- GENDER (Field8) — VARCHAR2
- P_IMG (Field9) — VARCHAR2
QNA (Untitled4)
- B_NO (Key) — NUMBER — Primary key — NOT NULL
- ID (Key2) — VARCHAR2 — Foreign key → PROFILE.ID — NOT NULL
- Q_TITLE (Field) — VARCHAR2
- Q_CONTENT (Field2) — VARCHAR2
- Q_PRIVATE (Field3) — VARCHAR2
- Q_DATE (Field4) — DATE
QUESTION (Untitled5)
- Q_NO (Key) — NUMBER — Primary key — NOT NULL
- QUESTION (Field) — VARCHAR2
Q_REPLE (Untitled9)
- B_NO (Key) — NUMBER — Foreign key → QNA.B_NO — NOT NULL
- ID (Key2) — VARCHAR2 — Foreign key → QNA.ID — NOT NULL
- Q_RE (Field) — VARCHAR2
TEST (Untitled6)
- ID (Key) — VARCHAR2 — Foreign key → PROFILE.ID — NOT NULL
- T_NO (Field) — NUMBER
- SCORE (Field2) — VARCHAR2