table

Tables (3)

MYMEDIA (Watched_movie)

  • MY_MEDIA_ID — NUMBER(10) — Primary key — NOT NULL
  • U_ID — varchar2(15) — Foreign key → N_USER.U_ID — NOT NULL
  • MEDIA_ID — NUMBER(10) — Foreign key → media.MEDIA_ID — NOT NULL

N_USER (User)

  • U_ID — varchar2(15) — Primary key — NOT NULL
  • U_PW — varchar2(15) — NOT NULL
  • U_NIK — varchar2(20) — NOT NULL
  • U_EMAIL — varchar2(20) — NOT NULL
  • JOINDATE — char(10) — NOT NULL
  • START_DAY — varchar(10) — NOT NULL
  • END_DAY — varchar(10) — NOT NULL
  • U_LEVEL — CHAR(1) — NOT NULL
  • GOLD — number(4) — NOT NULL
  • SILVER (silver) — number(4) — NOT NULL
  • BRONZE — number(4) — NOT NULL

media (Movie)

  • MEDIA_ID — NUMBER(10) — Primary key — NOT NULL
  • MEDIA_NM (Field) — VARCHAR(40) — NOT NULL
  • NATION (Field2) — VARCHAR2(15) — NOT NULL
  • MD_CATEGORY (Field3) — VARCHAR2(10) — NOT NULL
  • genre (Field7) — VARCHAR2(10) — NOT NULL
  • M_DATE (Field4) — VARCHAR2(10) — NOT NULL
  • RATING (Field5) — VARCAHR2(10) — NOT NULL
  • AUDIENCE (Field6) — NUMBER(10) — NOT NULL