ig
Tables (10)
Administrator (Untitled3)
- ID (Key) — VARCHAR2 — Foreign key → User.ID — NOT NULL
- PW (Key2) — VARCHAR2 — Foreign key → User.PW — NOT NULL
- EMAIL (Key3) — VARCHAR2 — Foreign key → User.EMAIL — NOT NULL
Follower (Untitled10)
- ICON (Key9) — IMAGE — Foreign key → Profile.ICON — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Foreign key → Profile.N_NAME — NOT NULL
- F_ICON (Field) — IMAGE
- F_NAME (Field2) — VARCHAR2
Following (Untitled9)
- ICON (Key9) — IMAGE — Foreign key → Profile.ICON — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Foreign key → Profile.N_NAME — NOT NULL
- F_ICON (Field) — IMAGE
- F_NAME (Field2) — VARCHAR2
Message (Untitled7)
- FROM_N_NAME (Key3) — VARCHAR2 — Foreign key → Profile.N_NAME — NOT NULL
- FROM_ICON (Key8) — IMAGE — Foreign key → Profile.ICON — NOT NULL
- TO_N_NAME (Field) — VARCHAR2
- TO_ICON (Field2) — IMAGE
- TEXT (Field3) — VARCHAR2
- FILE (Field4) — FILE
- M_DATE (Field5) — SYSDATE
- M_SEQ (Field6) — SEQUENCE
Post (Untitled5)
- ICON (Key) — IMAGE — Foreign key → Profile.ICON — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Foreign key → Profile.N_NAME — NOT NULL
- TEXT (Field) — VARCHAR2
- IMAGE (Field2) — IMAGE
- VIDEO (Field3) — VIDEO
- LIKE (Field4) — COUNT
- P_DATE (Field6) — SYSDATE
- P_SEQ (Field5) — SEQUENCE
Profile (Untitled4)
- ICON (Key9) — IMAGE — Primary key — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Foreign key → User.N_NAME — NOT NULL
- EMAIL (Key4) — VARCHAR2 — Foreign key → User.EMAIL — NOT NULL
- PHONE (Key5) — NUMBER — Foreign key → User.PHONE — NOT NULL
- NAME (Key6) — VARCHAR2 — Foreign key → User.NAME — NOT NULL
- B_DATE (Key7) — DATE — Foreign key → User.B_DATE — NOT NULL
- S_DATE (Key8) — SYSDATE — Foreign key → User.S_DATE — NOT NULL
- HEADER (Field) — IMAGE
- FOLLOWING (Field2) — COUNT
- FOLLOWER (Field3) — COUNT
- EMAIL_OPEN (Field4) — YES/NO/FRIEND
- PHONE_OPEN (Field5) — YES/NO/FRIEND
- NAME_OPEN (Field6) — YES/NO/FRIEND
- B_DATE_OPEN (Field7) — YES/NO/DATE
- ALL_OPEN (Field8) — YES/FRIEND
Reply (Untitled6)
- ICON (Key) — IMAGE — Foreign key → Post.ICON — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Foreign key → Post.N_NAME — NOT NULL
- TEXT (Field) — VARCHAR2
- R_DATE (Field3) — SYSDATE
- R_SEQ (Field2) — SEQUENCE
Search (Untitled8)
- N_NAME (Key3) — VARCHAR2 — Foreign key → User.N_NAME — NOT NULL
- EMAIL (Key4) — VARCHAR2 — Foreign key → User.EMAIL — NOT NULL
- PHONE (Key5) — NUMBER — Foreign key → User.PHONE — NOT NULL
Super User (Untitled2)
- ID (Key) — VARCHAR2 — Foreign key → User.ID — NOT NULL
- PW (Key2) — VARCHAR2 — Foreign key → User.PW — NOT NULL
- EMAIL (Key4) — VARCHAR2 — Foreign key → User.EMAIL — NOT NULL
- PHONE (Key5) — NUMBER — Foreign key → User.PHONE — NOT NULL
- NAME (Key6) — VARCHAR2 — Foreign key → User.NAME — NOT NULL
User (Untitled)
- ID (Key) — VARCHAR2 — Primary key — NOT NULL
- PW (Key2) — VARCHAR2 — Primary key — NOT NULL
- N_NAME (Key3) — VARCHAR2 — Primary key — NOT NULL
- EMAIL (Key4) — VARCHAR2 — Primary key — NOT NULL
- PHONE (Key5) — NUMBER — Primary key — NOT NULL
- NAME (Key6) — VARCHAR2 — Primary key — NOT NULL
- B_DATE (Key7) — DATE — Primary key — NOT NULL
- S_DATE (Key8) — SYSDATE — Primary key — NOT NULL