test

Tables (7)

member

  • id — NUMBER(30) — Primary key — NOT NULL
  • name — VARCHAR2(20) — NOT NULL
  • nickname — VARCHAR2(20) — NOT NULL
  • birth — VARCHAR2(30) — NOT NULL
  • email — VARCHAR2(50) — NOT NULL
  • reg_date — DATE

member_photo

    member_region

      member_tag

      • id — NUMBER(30) — Foreign key → member.id — NOT NULL
      • tag_id — NUMBER(30) — Foreign key → tag.tag_id — NOT NULL

      photo

      • photo_id — NUMBER(30) — Primary key — NOT NULL
      • dir — VARCHAR2(100)
      • filename — VARCHAR2(100)
      • originname — VARCHAR2(50)
      • filesize — NUMBER(30)
      • filetype — VARCHAR2(50)
      • reg_date — DATE

      region

      • region_id — NUMBER(30) — Primary key — NOT NULL
      • si — VARCHAR2(10) — NOT NULL
      • gu — VARCHAR2(10) — NOT NULL

      tag

      • tag_id — NUMBER(30) — Primary key — NOT NULL
      • tag_name — VARCHAR2(10) — NOT NULL