AppStore

Tables (5)

Review (Untitled2)

  • review_seq (PK) — int — Primary key — NOT NULL
  • content (Field) — VARCHAR(50)
  • score (Field2) — int
  • reg_date (Field3) — DATE
  • update_date (Field4) — DATE

Role (Untitled5)

  • role_seq (PK) — int — Primary key — NOT NULL
  • role (Field) — VARCHAR(20)
  • member_id (FK) — int

app (App)

  • app_seq (PK) — int — Primary key — NOT NULL
  • app_name (Field2) — VARCHAR(45)
  • app_content (Field) — VARCHAR(99)
  • install_yn (Field3) — VARCHAR(2)
  • app_path (Field4) — VARCHAR(300)
  • version (Field5) — DATE

member (Untitled)

  • member_seq (PK) — int — Primary key — NOT NULL
  • member_id (Field) — VARCHAR(40)
  • member_pw (Field2) — VARCHAR(40)
  • name (Field3) — VARCHAR(30)
  • role_seq (FK) — int

member_app_mapping (Untitled4)

  • app_seq (FK) — int — Primary key — NOT NULL
  • member_seq (fk) — int — Primary key — NOT NULL
  • reg_date (Field) — DATE