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