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