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