WITH U

Tables (9)

DIARY (Untitled5)

  • NO (Key) — NUMBER — Foreign key → FEED.NO — NOT NULL
  • ID (Key2) — VARCHAR2(50) — Foreign key → FEED.ID — NOT NULL
  • D_TITLE (Field) — VARCHAR2(50)
  • D_CONTENT (Field2) — VARCHAR2(4000)
  • D_IMG (Field3) — VARCHAR2(50)
  • D_PRIVATE (Field4) — NUMBER

D_DAY (Untitled6)

  • ID (Key) — VARCHAR2(50) — Foreign key → PROFILE.ID — NOT NULL
  • START (Field) — DATE
  • END (Field2)

FEED (Untitled2)

  • NO (Key) — NUMBER — Primary key — NOT NULL
  • ID (Key2) — VARCHAR2(50) — Foreign key → PROFILE.ID — NOT NULL
  • LIKE (Field3) — NUMBER
  • REPLE (Field) — VARCHAR2(500)
  • R_NO (Field2) — NUMBER
  • DATE (Field4) — DATETIME
  • TYPE (Field5) — NUMBER

ITEM_LIST (Untitled9)

  • I_NO (Key2) — NUMBER — Foreign key → LIKE_LIST.I_NO — NOT NULL
  • ID (Key) — VARCHAR2(50) — Foreign key → LIKE_LIST.ID — NOT NULL
  • I_NAME (Field) — VARCHAR2(50)
  • I_CONTENT (Field2) — VARCHAR2(500)
  • I_IMG (Field3) — VARCHAR2(50)
  • SAVE (Field4) — NUMBER

LIKE_LIST (Untitled8)

  • I_NO (Key2) — NUMBER — Primary key — NOT NULL
  • ID (Key) — VARCHAR2(50) — Foreign key → PROFILE.ID — NOT NULL

PROFILE (Untitled)

  • ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
  • PW (Field) — VARCHAR2(50)
  • NAME (Field2) — VARCHAR2(50)
  • NICK (Field3) — VARCHAR2(50)
  • TEL (Field4) — VARCHAR2(50)
  • ADDR (Field5) — VARCHAR2(50)
  • BIR (Field6) — DATE
  • GENDER (Field7) — VARCHAR2(50)
  • P_IMG (Field8) — VARCHAR2(50)

QUESTION (Untitled3)

  • Q_NO (Key) — NUMBER — Primary key — NOT NULL
  • NO (Key2) — NUMBER — Foreign key → FEED.NO — NOT NULL
  • ID (Key22) — VARCHAR2(50) — Foreign key → FEED.ID — NOT NULL
  • Q_CONTENT (Field) — VARCHAR2(4000)
  • Q_PRIVATE (Field2) — NUMBER

QUESTION_LIST (Untitled4)

  • Q_NO (Key) — NUMBER — Foreign key → QUESTION.Q_NO — NOT NULL
  • NO (Key2) — NUMBER — Foreign key → QUESTION.NO — NOT NULL
  • ID (Key22) — VARCHAR2(50) — Foreign key → QUESTION.ID — NOT NULL
  • QUESTION (Field) — VARCHAR2(500)

TEST (Untitled7)

  • ID (Key) — VARCHAR2(50) — Foreign key → PROFILE.ID — NOT NULL
  • SCORE1 (Field) — NUMBER
  • SCORE2 (Field2) — NUMBER
  • SCORE3 (Field3) — NUMBER