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