doc_attachment.py

# coding=utf-8

import arcpy

arcpy.env.workspace = r"Database Servers\WRICWLT111900_SQLEXPRESS.gds\cmr_forest_atlas (VERSION:dbo.DEFAULT)"
desc = arcpy.Describe(arcpy.env.workspace)

print desc.workspaceType

subtypes = {"9100100": "Loi",
            "9100200": "Code",
            "9100300": "Arrêté",
            "9200100": "Décret",
            "9200200": "Ordonnance",
            "9200300": "Protocole",
            "9200400": "Programme",
            "9200500": "Circulaire",
            "9200600": "Contrat",
            "9200700": "Convention",
            "9200800": "Cahier des charges",
            "9300100": "Avis public",
            "9300200": "Rapport",
            "9300300": "Notification",
            "9410100": "Plan d'aménagement",
            "9410200": "Plan de sondage",
            "9410300": "Inventaire",
            "9410301": "Inventaire d'aménagement",
            "9410302": "Inventaire d'exploitation",
            "9410303": "Inventaire de faune",
            "9420000": "Etude",
            "9420100": "Etude d'impact environnemental",
            "9430000": "Note",
            "9430100": "Note de conformité",
            "9440000": "Attestation",
            "9440100": "Attestation de superficie"}

tableList = arcpy.ListTables()
for table in tableList:
    if table[-6:] == 'ATTACH':
        fieldlist = arcpy.ListFields(table)
        if not "type_" in fieldlist:
            #add new fields
            arcpy.AddField_management(table, "type_", "LONG", field_alias="Type de document")
            arcpy.AddField_management(table, "desc_type", "TEXT", field_length=50, field_alias="Description")
            arcpy.AddField_management(table, "doc_titre", "TEXT", field_length=255, field_alias="Titre du document")
            arcpy.AddField_management(table, "doc_ref", "TEXT", field_length=255, field_alias="Référence du document")
            arcpy.AddField_management(table, "date_doc", "DATE", field_alias="Date du document")
            arcpy.AddField_management(table, "auteur", "TEXT", field_length=255, field_alias="Auteur")

            # Set subtype field
            arcpy.SetSubtypeField_management(table, "type_")

            # add subtypes and default value for description for each subtype
            for subtype in subtypes:
                arcpy.AddSubtype_management(table, subtype, subtypes[subtype])
                arcpy.AssignDefaultToField_management(table, "desc_type", subtypes[subtype], subtype)

            # Set Default Subtype...
            arcpy.SetDefaultSubtype_management(table, "9200100")